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;