How do I change user password under MySQL server? I’d like to change a password for user called tom using UNIX / Linux command line option.
First, login to MySQL server, type following command at shell prompt to login as root
$ mysql -u root -p
2) Use mysql database (type command at mysql> prompt, do not include string “mysql>”):
mysql> use mysql;
3) Change password for user tom:
mysql> update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom';
quoted from: www.cyberciti.biz