How-To create a MySQL database and set privileges to a user

On default settings, mysql root user do not need a password to authenticate from localhost. In this case, user 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 will create a database:
mysql> create database ramdb;
Query OK, 1 row affected (0.00 sec)
We allow user ramuser to connect to the server from localhost using the password rampasswd:
mysql> grant usage on *.* to ramuser@localhost identified by 'passwd';
Query OK, 0 rows affected (0.00 sec)
And finally we grant all privileges on the ramdb database to this user:
mysql> grant all privileges on ramdb.* to ramuser@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 ramuser -p'passwd' ramdb
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>