How to Change MySQL Password for Other Users
By Angsuman Chakraborty, Gaea News NetworkSaturday, 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
YOUR VIEW POINT