Changing user passwords in mysql

Again this is taken directly from mysql.com

You need to login into mysql and run the following sql:

UPDATE mysql.user SET Password=PASSWORD("<NEW_PASSWORD>") where user="<USER_NAME>"

You have to connect to do this and easiest is to connect as the root user:

mysql --user=root