Mysql Access denied for root user:
=========================
This is works with mariadb
show grants for 'root'@'localhost';
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
flush privileges; exit
Comments
Post a Comment