Skip to main content

Mysql Access Denied for ROOT user

Mysql Access denied for root user:
=========================

This is works with mariadb 

show grants for 'root'@'localhost';

UPDATE mysql.user SET authentication_string=PASSWORD('yourpass') WHERE User='root;
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User='root';

flush privileges; 
exit



Comments