mysql>use mysql; mysql>update user set password=PASSWORD('[Password]') where user='[Name of user]';Note, to change the password from the account you are already in, you do not need to specify user i.e.:<
mysql>set password=PASSWORD('[password]')The second designation of PASSWORD is actually a function call, one that encrypts, or hashes the password you supply.
Also, keep in mind that, after any password updates you must flush privileges:
mysql>flush privileges;And jumping back out to the command line and restarting MySql is not a bad idea, either:
mysql> quit # /etc/init.d/mysql stop # /etc/init.d/mysql startInfo taken from here and here, and, if you really get into trouble, here.