Passwords
To set a root password when the root password is currently blank:
mysqladmin -u root password <newpassword>
To change passwords in general:
1. Login to the mysql command line interface with the user's current password:
mysql -u <username> -p
2. At the "mysql>" prompt, type: set password = password("newpassword");