MySQL, Adding Users
To add new users to mysql use the following commands (if you haven't set a password for the mysql root user, leave off the -p):
oyabun# mysql -u root mysql -p password: > GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;
Note: that command grants full privileges on ALL databases to "user@localhost", effectively creating a new mysql root user, which is usually not what you want. More frequently, you will want to GRANT ALL PRIVILEGES ON [[databasename]].* or something similar.