change the password of MySQL user

change the password of MySQL user

Open the bash shell and connect to the server as root user:

mysql -u root -h localhost -p

Run ALTER mysql command:

ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';

Finally type SQL command to reload the grant tables in the mysql database:

FLUSH PRIVILEGES;


Leave a Reply