HowTo : Create MySQL Database from the Command Line

Creating MySQL Database from the command line is quite a common task.

We'll create database named test_db with a user named john and a password pass.

User will have all privileges on this database and will be allowed to connect only from the localhost.