Create a schema

1. Open your Workbench. If you have set it up correctly, a MySQL Local instance will appear on the homepage.

   

2. Double click on Local instance. A login popup window will appear. Enter your username and password, then press OK to proceed.

   

    ⚠️: You cannot use MySQL Workbench if you skip this step.
    > Connecting to a local instance will grant you access to your MySQL database.
   

   Once successfully logged in, you will see this layout.

   

3. In the top left corner of Workbench, click on the icon with the word ‘SQL’ and a ‘+’ sign.

   

   A SQL tab will appear in the middle of the MySQL Workbench layout. This is the place where you add and execute all of your SQL queries.

   

4. Copy and paste this line of SQL code into the newly created SQL file.

    CREATE SCHEMA IF NOT EXISTS user_demo;
   

5. Click the thunder icon at the top of the SQL tab to execute the SQL file.

   

    ⚠️: This icon will execute every SQL query that exists in the SQL file.
    > Make sure you write the queries correctly before clicking this icon.
   

   After executing the SQL queries, the Output tab below will show the status of the execution. If you see the green checkmark, the queries have run successfully.

   

   Your schema has been created. However, it has not shown up in the Schemas tab. Therefore, you need to reload the Schemas tab.

6. Hover your cursor over the Schemas tab. Right click and select ‘Refresh All’.

   

   The newly created schema will now appear in the Schemas tab.

   

   Next, we will create our first table inside this new schema, ‘user_demo’.