Page 167 - IT-802_class_12
P. 167
10 Type the password for the root user.
11 Click on the Next button twice.
10
11
12 Click on the Execute button.
13 Click on the Finish button.
Once the setup is downloaded, double-click on it to start the installation.
1.4.2 Creating a Database
The CREATE DATABASE command is used to create a database in MySQL.
Syntax:
CREATE DATABASE Database_Name;
Example:
CREATE DATABASE SCHOOL;
After creating a database in MySQL, we need to open it by using the following command:
USE Database_Name;
Example:
USE SCHOOL;
Now, we can create tables in the database.
1.4.3 Show Database
This command helps to show all databases.
Syntax:
SHOW DATABASES;
Output:
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| school |
| sys |
+--------------------+
Database Concepts—RDBMS Tool 165

