This topic is a cheat sheet on how to change the password of a user (any user) in the MySQL DBMS.
Method 1:
# mysqladmin -u username -p'oldpassword' password NEWPASSWORD
or
# mysqladmin -u username@'hostname' -p'oldpassword' password NEWPASSWORD
Method 2:
# mysql -u root -p
Password:
...
mysql> UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User = 'username' AND host = 'hostname';
Something like that, roughly.
Comments