Create a new MySQL database using Workbench

mysql database mysql-workbench eer-model
jb. picture jb. · Jan 31, 2012 · Viewed 23k times · Source

I'm just trying to create a new MySQL database with a few simple tables.

I created a new EER Model in Workbench so I have the database modeled I want it, with all the tables/fields I need. I don't see any way to take the model and create an actual database out of it. Right now it just created a .mwb "MySQL Workbench file".

I saw this question which is outdated as it's for Workbench (5.2.33) and it talks about "on the left pane there is a section titled 'Object' " which doesn't appear to exist in (5.2.36).

Does Workbench even have the capabilities to create a database or is it only for connecting/editing existing databases? If Workbench can't create new databases, what is a simple tool that will?

I'm using MySQL Workbench (5.2.36) on Win 7.

Answer

Colin Brock picture Colin Brock · Jan 31, 2012

I believe you want to select the "Database" menu and then select "Forward Engineer".

Related questions

Authentication plugin 'caching_sha2_password' cannot be loaded

I am connecting MySQL - 8.0 with MySQL Workbench and getting the below error: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found I have tried with other client …

Read More
Can't connect to MySQL server on '127.0.0.1' (10061) (2003)

I know this question was asked a lot before but I tried some of the solutions which were given and nothing worked.. I have downloaded MySQL Workbench 6.1 on my windows 7 x64 and now as I want to start and do …

Read More
Error Code: 2013. Lost connection to MySQL server during query

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away …

Read More