Here are steps explained below to create mysql database and tables from shell
1)Create database from shell
Use the SHOW statement to find out what databases currently exist on the server:
mysql> SHOW DATABASES;
Create database from shell as per following
mysql> create datbase testdb;
mysql> USE testdb;
Database changed
2) Grant privileges of database to specific user
mysql> GRANT ALL ON testdb.* [...]