Skip to content

Instantly share code, notes, and snippets.

@pierophp

pierophp/resetting_mysql_root_password

Last active December 29, 2016 19:09
Show Gist options
  • Save pierophp/6c3036850abe80963460da07f56b6c85 to your computer and use it in GitHub Desktop.
Save pierophp/6c3036850abe80963460da07f56b6c85 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
resetting_mysql_root_password
sudo systemctl stop mysql
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking
mysql -u root
UPDATE mysql.user SET plugin = 'mysql_native_password', authentication_string = PASSWORD('root') WHERE user = 'root';
FLUSH PRIVILEGES;
sudo systemctl start mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment