#CREATE A DATABASE WORKBENCH IN MYSQL HOW TO#

As with creating your database, you can create your tables either programmatically or via the GUI. There are two ways to create a new database: Locate the Schema section in the sidebar on the left side and right-click the white (blank) area. Choose the database server you have access to and connect to it. To create a database, you first need to open Workbench.

#CREATE A DATABASE WORKBENCH IN MYSQL HOW TO#

You can also add code that checks for the existence of any databases that already use that name. How to Use MySQL Workbench to Create a Database. This is as quick and easy as writing CREATE DATABASE VegeShop. You can tell when a database is the default database because its name is rendered in a bold typeface: Creating Databases ProgramaticallyĪs mentioned, you can also create your databases programmatically. You can set the new database as the default database by right-clicking on it and selecting Set as Default Schema: You will now see your new database listed under the SCHEMAS tab on the left pane: Setting the Default Database You should see the following screen once the database has been created:.To run the statement (and create the database) click Apply: You are prompted to review the SQL statement that will be run to create the database.Enter the schema name (in this case, VegeShop) and the default collation (in this case, latin1 - default collation), then click the Apply button:.Click the icon for creating a new schema (you'll find this on the Workbench toolbar):.In the following example, we create a new database called 'VegeShop'. You can also create a database programmatically but here's how to do it via the GUI. You can use the MySQL Workbench GUI to create a database.

Create a database workbench in mysql