Hi,

First of all you have to connect to MySQL database through command line tool.

Connecting to MySQL Database:

mysql -uroot -p

Here in -uroot, root is the username of database. Replace this with your database user name for example if your username is 'abc' then the command will be:

mysql -uabc -p

Press enter on the command prompt/terminal and mysql command line tool will ask for the password. Enter the password and if password is correct mysql prompt will open.

deepak@deepakub16:~$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.12-0ubuntu1.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Now to create database use following command:

mysql> CREATE DATABASE tutorial;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| tutorial           |
+--------------------+
5 rows in set (0.00 sec)

The show databases; command displays the names of the databases.

Now you have to connect to database, type following command:

mysql> connect tutorial;
Connection id:    6
Current database: tutorial

Here is the sql to create table:

mysql> CREATE TABLE email
    -> (
    -> first_name varchar(20),
    -> last_name varchar(20),
    -> email varchar(40),
    -> email_count Int
    -> )
    -> ;
Query OK, 0 rows affected (0.02 sec)

Following command displays the newly created table:

mysql> show tables;
+--------------------+
| Tables_in_tutorial |
+--------------------+
| email              |
+--------------------+
1 row in set (0.00 sec)

mysql>

Check more tutorials at Create a database.

Check 100s of tutorials of SQL at SQL Tutorials with MySQL Database.

Thanks