Once MySQL Server setup is done , lets start by creating a database , in our example we will see how to create a MySQL Database
Step 1) Login to MySQL
we will be using user : demo and password as demouser
mysql -u demo -p demouser
Step 2) Now we will be creating a database demo
mysql> create database demo;
Query OK, 1 row affected (0.00 sec)
Step 3) Checking if the database is created ;
mysql>show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| demo |
| test |
+——————–+
3 rows in set (0.00 sec)
we can see that the database demo is there in the list . in next post we will see how to create tables in a MySQL.
