about


Scribe:

chrono

blog

Time

science!

book musings

gov

'punk

missle defense

jams

antiques

cultcha blog


Construct:

scripts & programs

on the town

snaps


Self:

creds (PDF)

key

missive


MySQL: Updating Passwords

Updating a password can be done within mysql, by root, thusly:<
 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 start
Info taken from here and here, and, if you really get into trouble, here.