Create Database in MySQL

Create Database in MySQL:

(1) In order to create a database in MySQL, first of all, we need to install MySQL.

(2) After installing MySQL, search for MySQL Workbench and open it as shown below.

Open MySQL Workbench

(3) Now click on MySQL Connections as shown below.

MySQL Connections for root user

(4) Now we are logging into the MySQL Workbench. In order to create a new database in MySQL, click on a symbol at the top menu bar that shows “Create a new schema in the connected server” as shown below.

Create a new schema in the connected server in MySQL

(5) Now enter the database name. For example, I have named my database “Gkscientistdb1” and clicked on Apply as shown below.

enter new database name in mysql

(6) After that a new window opens i.e “Review the SQL Script to be applied on the Database” and then click Apply as shown below.

Review SQL Script

(7) After that you find the SQL script was successfully applied to the database and then click on Finish as shown below.

SQL script was successfully applied to the database

(8) Now under schema, you will find the database that you have created.

database created in MySQL

Database Management System (DBMS)
Google Search Console and Google Analytics
Client-Server Architecture
Multimedia and Its Application
Information Security in E-Commerce
Computer Software and Hardware
MySQL– Wikipedia

Comments (No)

Leave a Reply