Setting MySQL Password

August 23, 2006

To set up root password the first time:

$ mysqladmin -u root password NeWPasSwORd

To change an existing root password:

$ mysqladmin -u root -p oldpassword newpass
Enter password:

To change a normal user password:

$ mysqladmin -u dbuser-p oldpassword newpass

Bad Behavior has blocked 21 access attempts in the last 7 days.