How to change your password in MySQL

Need to change your password in MySQL? It’s pretty simple. Here is the command:

[code]
mysql> update mysql.user set Password=PASSWORD(‘NEWPASSWORD’) where User=’YOURUSERNAME’ AND Host=’localhost’;

mysql> flush privileges;
[/code]

Leave a Reply

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