Simple Example to create a MySQL database and set privileges to a user

On a default settings, mysql root user do not need a password to authenticate from localhost. In this case, ou can login as root on your mysql server using:

$ mysql -u root

If a password is required, use the extra switch -p:

$ mysql -u root -p
Enter password:

Now that you are logged in, we create a database:

mysql> create database drupaldb;
Query OK, 1 row affected (0.00 sec)

We allow user amarokuser to connect to the server from localhost using the password amarokpasswd:

mysql> grant usage on *.* to drupaluser@localhost identified by 'drupalpasswd';
Query OK, 0 rows affected (0.00 sec) 

And finally we grant all privileges on the amarok database to this user:

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

And that's it. You can now check that you can connect to the MySQL server using this command:

$ mysql -u drupaluser -p'drupalpasswd' drupaldb