Often times you'll find yourself wanting to quickly create a database in your MySQL installation for some project you are working on. Follow this quick guide to do so.
We're going to create a database named 'testing' with a user named 'test_user' and a password of 'test_pass'. We're going to give him all privileges on this database and allow him to connect only from localhost.
First, log into the mysql shell as a privileged user:
root@localhost:~# mysql -u root -p
Now, create your database:
mysql> CREATE DATABASE testing;
Now, add your user and his access:
mysql> GRANT ALL PRIVILEGES ON testing.* TO test_user@localhost IDENTIFIED BY 'test_pass';