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

Start a Project




    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home