Thursday, June 21, 2018

MySQL reset root password


$ sudo mysql -u root

mysql> uninstall plugin validate_password;

mysql> update user set authentication_string=password('root') where user='root';

mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';

mysql> flush privileges;

​mysql> quit

$ sudo systemctl restart mysql

No comments:

Post a Comment