什么是好的 MySQL 数据库架构工具？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/598437/
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
What is a good MySQL Database Schema tool?
提问by Drew
I'm starting a new project soon and I'd like to try to use some better tools this time around. The last project, I wrote all my Database creation SQL by hand for MySQL. I'm hoping there are some good tools out there for creating, maintaining and modifying database schema in MySQL. My budget is out-of-my-own-pocket, so free (as in beer) would probably be best. :)
我即将开始一个新项目，这次我想尝试使用一些更好的工具。最后一个项目，我为 MySQL 手工编写了我所有的数据库创建 SQL。我希望有一些好的工具可以在 MySQL 中创建、维护和修改数据库模式。我的预算是自掏腰包，所以免费（如啤酒）可能是最好的。:)
回答by HyperCas
MySQL Workbench : http://dev.mysql.com/workbench/
MySQL 工作台：http: //dev.mysql.com/workbench/
It is free and very easy to use. I usually create schema diagrams and export it as a .sql file to use with phpMyAdmin
它是免费的并且非常容易使用。我通常创建架构图并将其导出为 .sql 文件以与 phpMyAdmin 一起使用
回答by TheTXI
http://dev.mysql.com/downloads/gui-tools/5.0.htmloffers a list of GUI tools to use.
http://dev.mysql.com/downloads/gui-tools/5.0.html提供了要使用的 GUI 工具列表。
回答by Kendall Helmstetter Gelner
Mac options, try Querious or Sequel Pro - here's a comparison:
Mac 选项，尝试 Querious 或 Sequel Pro - 这是一个比较：
http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/
http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/
回答by Kendall Helmstetter Gelner
A complete list of data modeling tools can be found at databaseanwers
可以在databaseanwers找到完整的数据建模工具列表
回答by batfastad
I know this is an old thread but this is too good to miss out on. I've only just found out about this recently...
HeidiSQL
我知道这是一个旧线程，但这太好了，不容错过。我最近才发现这个...
HeidiSQL
It supports connecting through SSH tunnels. It uses PuTTY (plink.exe) to do this but avoids having to manually fiddle with your PuTTY settings. It's even easier if you're using this nice portable version of PuTTY... http://jakub.kotrla.net/putty/
它支持通过 SSH 隧道连接。它使用 PuTTY (plink.exe) 来执行此操作，但避免了必须手动调整 PuTTY 设置。如果你使用这个漂亮的 PuTTY 便携版本，那就更容易了... http://jakub.kotrla.net/putty/
Plus it's open source. I strongly urge you to donate though as it's a great tool.
另外它是开源的。我强烈敦促您捐赠，因为它是一个很好的工具。
Another one that looks good is DBeaver
另一个看起来不错的是DBeaver
I used to really like MySQL Administrator but the new Workbench is way too bloated. I just want a quick way to browse the schema without having to SHOW TABLE STATUS
我曾经非常喜欢 MySQL Administrator，但新的 Workbench 太臃肿了。我只想要一种快速浏览模式的方法，而不必SHOW TABLE STATUS
回答by batfastad
MySQL Workbench 5.1 (Beta 1) should be out March 6,2009. It will be available on MacOS, Fedora, Ubuntu, Windows. These are nativeC++ implementations on each platform. WB 5.1 is focused on Data Modeling (replacing Mike Zinner's popular DBDesigner product).
MySQL Workbench 5.1 (Beta 1) 应该会在 2009 年 3 月 6 日发布。它将在 MacOS、Fedora、Ubuntu、Windows 上可用。这些是每个平台上的本机C++ 实现。WB 5.1 专注于数据建模（取代 Mike Zinner 流行的 DBDesigner 产品）。
MySQL Workbench 5.2 (Alpha 1) should be out mid April 2009 (around the MySQL Users Conference 2009). This will include a ground up rewrite of the MySQL Query Browser.
MySQL Workbench 5.2 (Alpha 1) 应该会在 2009 年 4 月中旬发布（大约在 2009 年 MySQL 用户大会上）。这将包括对 MySQL 查询浏览器的彻底重写。
