Cloudkul Support

How to Fix “ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)” Issue for MySql ?

To fix this error, run the following commands,

mysql -u root -pYour_password -e UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

mysql -u root -pYour_password -e GRANT ALL ON *.* TO 'root'@'localhost';

mysql -u root -pYour_password -e flush privileges;


Is this article is helpful?

People like and 1 people dislike.

If result is not found or irrelevant, Please contact us.

Submit your request