Create a new database with MySQL Workbench?

MySQLMySQLi Database

To create a new database with MySQL Workbench, you need to launch MySQL workbench. The screenshot is as follows.

Now, let us test connection with MySQL. Follow the below steps −

Database->Connect to database (Ctrl +U).

The following is the screenshot that displays the “Connect to Database” dialog box. Add password to continue.

After that, you need to press the OK button twice to establish a connection.

Now, to create a database, you need to click the symbol shown in the following screenshot −

After clicking the symbol, you will get the following wizard to create a database −

In the above wizard, you need to give the database name. I have given the database name “Education”.

Now, you need to press the “Apply” button.

After pressing the apply button, we will get another wizard as shown above. This itself states that we have successfully created the database. You can check whether the database has been created or not under the “Schemas” tab as shown in the following screenshot −

raja
Published on 21-Dec-2018 10:22:09
Advertisements