You can create a MySQL database by using MySQL Command Line Client.
Open the MySQL console and write down password, if you set one while installation. You will get the following:
Now you are ready to create database.
- CREATE DATABASE database_name;
Let’s take an example to create a database name “employees”
- CREATE DATABASE employees;
It will look like this:
You can check the created database by the following query:
- SHOW DATABASES;
Here, you can see the all created databases.