How to Change MySQL Password for Other UsersBy Angsuman Chakraborty, Gaea News Network
Saturday, January 17, 2009
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