the difference between mysql server and mysql workbench

Question

I've instaled MySQL workbench in Windows 7 64bit. Unfortunately, I'm facing problems:

In the Object Browser, when I click on my DB and right click on tables to create one, I can not insert any column (disabled) and therefore, can not insert tables. check this: Can not create table in MySQL workbench 5.2.40

I can create table from the EER model. But even though, I faced problems when tried to connect my Java application to this database. MySQL and Java: table doesn't exist

I have searched, and not sure from this, some of what I found is that workbench have probelms with Windows 7 - 64 bit (any idea if this is correct??). The only version I found was for 68, it installed successfully but I'm having probems.

I want to downlod MySQL server but before that: Will Mysql Server give me the same features that the workbench does? I need to work with GUI (insert, delete, update,..etc).

EDIT:

Also, the table I added using the EER are not visible in the Object browser. I only can see the schema in the Object browser without any table underneath it.

Answer 1

MySQL Workbench is a MySQL Server GUI. The two are different products. MySQL Workbench requires a MySQL Server connection for most tasks (except for data modeling). This reliance on a MySQL connection is clearer in the latest version of MySQL Workbench (6.1) than it was in 5.2.