MYSQL - Create Database

1. Open your terminal. 

2. Connect to MySql.If not use below link to know how to connect.

How to Connect to MySql Database using MAC terminal

3. Once you logged into your mysql then type the below command 
to create a database.
mysql> CREATE DATABASE OMS;
Query OK, 1 row affected (0.00 sec)   
1 row affected means Database is created successfully.

4. To use this Database OMS type below command.
mysql> USE OMS;
Database changed

5. Check which database you are using by using below command.
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| oms        |
+------------+
1 row in set (0.00 sec)


***********Happy Learning*************