$ 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