How to change your password in MySQL

Posted by on Jan 25, 2012 in Support, Web Development | No Comments

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

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

mysql> flush privileges;