How-To Create A MySQL Database And Set Privileges To A User

Install mysql:

1. apt-get install mysql-server

2. $ mysql -u root -p
Enter password:

3. mysql > create database amarokdb;
Query OK, 1 row affected (0.00 sec)

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

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

6.$ mysql -u amarokuser -p’amarokpasswd’ amarokdb

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