If you have installed MySQL yourself and have never set a root password, you can do so by running this command via SSH:
# mysqladmin -u root password NEWPASSWORD
To update your MySQL root password from an existing password, use the following (the default MySQL password in our LAMP templates is "host2=="):
# mysqladmin -u root -p'oldpassword' password newpass
To update the password of a user besides root:
# mysqladmin -u vivek -p oldpassword password newpass
