Skip to content

Instantly share code, notes, and snippets.

@danilkuznetsov

danilkuznetsov/update mysql user field host

Last active November 3, 2016 11:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danilkuznetsov/a299d45fae3cf09b08326236fa6334c8 to your computer and use it in GitHub Desktop.
Save danilkuznetsov/a299d45fae3cf09b08326236fa6334c8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update mysql user field host
UPDATE mysql.user SET host = '%' WHERE host = 'localhost' AND user != 'root';
UPDATE mysql.db SET host = '%' WHERE host = 'localhost' AND user != 'root';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment