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