How to reset MySQL user password in Linux

Step1: Login to MySQL as root.

Step2: Run the query to change the user password.

ALTER USER 'user-name'@'localhost' IDENTIFIED BY 'user-password';

Here we need to replace user-name and user-password with the respective values.

Step3: Reload the privileges.

FLUSH PRIVILEGES;

That's all…

Leave a Reply

Your email address will not be published. Required fields are marked *