MySQL mysql服务器和mysql工作台的区别
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11248215/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
the difference between mysql server and mysql workbench
提问by Jury A
I've instaled MySQL workbench in Windows 7 64bit. Unfortunately, I'm facing problems:
我已经在 Windows 7 64 位中安装了 MySQL 工作台。不幸的是，我面临以下问题：
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
在对象浏览器中，当我单击我的数据库并右键单击表以创建一个时，我无法插入任何列（已禁用），因此无法插入表。检查这个： 无法在 MySQL 工作台 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
我可以从 EER 模型创建表。但即便如此，我在尝试将 Java 应用程序连接到该数据库时也遇到了问题。 MySQL 和 Java：表不存在
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.
我已经搜索过，但不确定，我发现的一些东西是工作台有 Windows 7 - 64 位的问题（知道这是否正确？？）。我找到的唯一版本是 68，它安装成功，但我有问题。
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).
我想下载 MySQL 服务器，但在此之前：Mysql Server 会提供与工作台相同的功能吗？我需要使用 GUI（插入、删除、更新等）。
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.
此外，我使用 EER 添加的表在对象浏览器中不可见。我只能在对象浏览器中看到架构，下面没有任何表格。
采纳答案by jcho360
Both are for manipulate the structure, queries and function, procedure, etc....
两者都是用于操作结构，查询和函数，过程等......
In Both you can Use DML and DDL
在两者中，您都可以使用 DML 和 DDL
If you ask me I love Server even if you can create really cool designs on workbench, but basically you can do the same in both (insert, delete, update,..etc and more)
如果你问我我喜欢服务器，即使你可以在工作台上创建非常酷的设计，但基本上你可以在两者中做同样的事情（插入、删除、更新等等）
So it's up to you, I think MySQL server is a little bit lighter that Workbench, but if you want to, try it both.
所以这取决于你，我认为 MySQL 服务器比 Workbench 轻一点，但如果你想，两个都试试。
Workbench looks like more friendly
Workbench 看起来更友好
回答by Philip Olson
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.
MySQL Workbench 是一个 MySQL 服务器 GUI。两者是不同的产品。MySQL Workbench 需要连接 MySQL Server 才能完成大多数任务（数据建模除外）。这种对 MySQL 连接的依赖在最新版本的 MySQL Workbench (6.1) 中比在 5.2 中更加明显。
回答by Devinder Singh
MySql Workbench and MySql Server both are completely different things. MySql Server is basically a database and MySql workbench is a GUI or graphical management tool which helps us interact with MySql server database.
MySql Workbench 和 MySql Server 都是完全不同的东西。MySql Server 基本上是一个数据库，而 MySql workbench 是一个 GUI 或图形管理工具，可以帮助我们与 MySql server 数据库进行交互。
Similarly, SQL Server Management Studio is the graphical management tool for SQL Server.
同样，SQL Server Management Studio 是 SQL Server 的图形管理工具。
