Thursday, April 5, 2012

how to change MySQL user password with console(MySQL console)

login to the MySQL  server with the console provided.

mysql  -uroot -p

then  change the database as mysql

use mysql;

then use the following command to change the root password

//the new password of the user whose password should be changed
update user set password=PASSWORD("abc123") where User='root';

Hope this will helpful for you!!!

Thanks and Regards
Chathuranga Tenakoon

No comments:

Post a Comment