mysql how to fix Access denied for user 'root'@'localhost'

sudo mysql -u root
use mysql;
[mysql] update user set plugin='mysql_native_password' where User='root';
[mysql] flush privileges;

Now you should be able to login with your password.

Comments

Popular posts from this blog

Encrypt MySQL data using AES techniques