the root password for the mysql superuser is in /root/.my.cnf

         user@conway:~$ mysql -u root -p mysql

         Enter password:

         Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 562 to server version:

         3.22.32-log

         Type 'help' for help.

         mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP on db_name_here.* to user_name_here@localhost IDENTIFIED by

         'clear_text_password_here';

         mysql>\q Bye

         check out the MySQL documentation to see what the different types of PERMISSIONS settings you can give to the GRANT

         statement.

         andy@cat.org.au, safari@cat.org.au

         http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management

         is a good link.
         NOTE:: The above GRANT command is how you create new users..

         to update the password , use SET PASSWORD

         Example::

          GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP on *.* to andy@'%' IDENTIFIED by 'Example!Password';

         adds a new user, andy, to connect from any host..

         andy (at) cat.org.au