Create MySQL database on command line

mysql -u root -p     
mysql> CREATE DATABASE testing;
mysql> GRANT ALL PRIVILEGES ON testing.* TO test_user@localhost IDENTIFIED BY 'test_pass';