Create a new database with MySQL Workbench
- Launch MySQL Workbench.
- On the left pane of the welcome window, choose a database to connect to under "Open Connection to Start Querying".
- The query window will open. On its left pane, there is a section titled "Object Browser", which shows the list of databases. (Side note: The terms "schema" and "database" are synonymous in this program.)
- Right-click on one of the existing databases and click "Create Schema...". This will launch a wizard that will help you create a database.
If you'd prefer to do it in SQL, enter this query into the query window:
CREATE SCHEMA Test
Press CTRL + Enter to submit it, and you should see confirmation in the output pane underneath the query window. You'll have to right-click on an existing schema in the Object panel and click "Refresh All" to see it show up, though.
Click the database symbol with the plus sign (shown in the below picture). Enter a name and click Apply
.
This worked in MySQL Workbench 6.0
How to create database in MySQL Workbench 6.3
- In tab home (1) -> Right click on Local instance banner (2) -> Open Connection (3)
- Right click on the empty space in schema window (1) -> Create schema (2)
- Type name of database (1) -> Apply (2)