Skip to content

Instantly share code, notes, and snippets.

@marcialsoto
Last active January 28, 2019 14:07
Show Gist options
  • Select an option

  • Save marcialsoto/ed827d8acdda7011c0984e7c50cddd83 to your computer and use it in GitHub Desktop.

Select an option

Save marcialsoto/ed827d8acdda7011c0984e7c50cddd83 to your computer and use it in GitHub Desktop.
sudo mysql
use mysql;
UPDATE mysql.user SET plugin = "mysql_native_password" WHERE User="root";
UPDATE user SET authentication_string=PASSWORD("root") WHERE User="root";
flush privileges; exit
##
sudo service mysql stop
sudo usermod -d /var/lib/mysql/ mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment