A database is a container that organises and holds all your tables. You can think of it like a project folder that keeps related data tables together.

In the query editor enter the following SQL and click the yellow lightning bolt icon:

CREATE DATABASE blog;
USE blog;
  • CREATE DATABASE makes a new database, in this case called blog
  • USE switches into that database so future commands apply to it

In the output window below the query editor you should see a success message for each command.

Verify Your Database

You can check that your database was created with:

SHOW DATABASES;

This lists all databases on your MySQL server. You should see blog in the list.

If you right-click in the Schemas tab and select Refresh All you should also see the list of databases.

Select Your Database

Duoble-click blog from the DB list in the Schema tab so future SQL scripts apply to that DB.


Tags: