How-To create a MySQL database and set privileges to a user http://www.debuntu.org/how-to-create-a-mysql-database-and-set-privileges-to-a-user/

mysql-create-user.sh

$ mysql -u root -p
Enter password:
  
mysql> create database amarokdb;
Query OK, 1 row affected (0.00 sec)

mysql> grant usage on *.* to amarokuser@localhost identified by ‘amarokpasswd’;
Query OK, 0 rows affected (0.00 sec)

mysql> grant usage on *.* to amarokuser@localhost identified by ‘amarokpasswd’;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on amarokdb.* to amarokuser@localhost ;
Query OK, 0 rows affected (0.00 sec)

$ mysql -u amarokuser -p’amarokpasswd’ amarokdb
Your MySQL connection id is 12
Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution
 
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql>