How Do I Create a New Database in MySQL

A database is utilized to avoid wasting the gathering of data in a readable kind. It lets customers simply maintain the information in tables’ columns, rows, and indexes to get comparable info. Moreover, customers can entry and handle the data by means of the database simply.

This weblog will present the method to make a brand new database utilizing a terminal in MySQL.

The way to Create/Make a New Database Utilizing Terminal in MySQL?

You may create/make a brand new database by using the terminal in MySQL. Observe the below-given directions:

Step 1: Launch Home windows Terminal

At first, search the “Command Immediate” with the assistance of the Startup menu:

Step 2: Join Terminal With MySQL

Run the supplied command to attach the terminal with the MySQL server by using the next command:

Step 3: Show Databases

Now, view the record of all present databases by executing the “SHOW” command:

Step 4: Create New Database

Lastly, create a brand new database by using the “CREATE” command with the “DATABASE” possibility and database title:

As you’ll be able to see, the brand new database has been created efficiently:

Step 5: Confirm New Database

Lastly, use the “SHOW” command to view the record of databases and be sure that the brand new database created or not:

As you’ll be able to see, “mynewdb” exists within the record:

That’s all! We’ve got supplied the process to create a brand new database in MySQL utilizing a Home windows terminal.

Conclusion

To create a brand new database in MySQL utilizing the terminal, first, launch the Home windows terminal and join with the MySQL server. Then, show the prevailing databases and execute the “CREATE DATABASE <new-databasename>” command. This weblog illustrated the strategy to create/make a brand new database in MySQL utilizing the terminal.