Skip to content

Instantly share code, notes, and snippets.

@AustinWinstanley

AustinWinstanley/authorize-root.sql

Created April 24, 2017 19:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save AustinWinstanley/8dc1e071a12342ff7ebc9cecb8f471ab to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save AustinWinstanley/8dc1e071a12342ff7ebc9cecb8f471ab to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. AustinWinstanley created this gist Apr 24, 2017.
    2 changes: 2 additions & 0 deletions authorize-root.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,2 @@
    -- Insecure, do not use in production
    UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';