Wednesday, December 9, 2009

How to Change MySQL Password for Other Users

Do you get this error message when you try to change the root password?

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Or may be you need to change the MySQL password for other users. So what do you do then?

To change a normal user password you need to type:
$ mysqladmin -u user-name -p oldpassword newpass

No comments:

Post a Comment