Mysql 可视化工具
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/363658/
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
Mysql Visualization Tools
提问by Electronic Zebra
Does anyone know a good (preferably open source and cross platform) tool to allow simple visualization of mysql databases? I just need a tool I can quickly point at a database and it'll show basic table structure and field types, etc. Nothing too advanced or crazy.
有谁知道一个好的(最好是开源和跨平台的)工具来允许对 mysql 数据库进行简单的可视化?我只需要一个工具,我可以快速指向一个数据库,它会显示基本的表结构和字段类型等。没有什么太高级或太疯狂了。
采纳答案by djn
MySQL Workbenchruns on Windows and Linux. The commercial version will let you reverse engineer and edit the stucture of a live database, with the free one you have first to dump the structure to a file. Its ancestor DBDesigneris a bit older, but doesn't have this limitation. Windows and Linux too.
MySQL Workbench在 Windows 和 Linux 上运行。商业版可以让你逆向工程和编辑实时数据库的结构,免费版可以先将结构转储到文件中。它的祖先DBDesigner有点老,但没有这个限制。Windows 和 Linux 也是如此。
If these two are overkill you may try with HeidiSQL, the descendant of MySQLFront. It runs on Windows only, but there is an alpha version running on Java.
如果这两个是矫枉过正,您可以尝试使用HeidiSQL,MySQLFront的后代。它仅在 Windows 上运行,但有一个在 Java 上运行的 alpha 版本。
回答by Eli
I really like Sqlyogon Windows. It is (technically) open source, but not cross-platform. (Scroll down to "community edition")
我真的很喜欢Windows 上的Sqlyog。它(技术上)是开源的,但不是跨平台的。(向下滚动到“社区版”)
If your requirements are open source, simple, and cross-platform, hav eyou considered setting up a website with phpMyAdmin?
如果你的需求是开源、简单、跨平台,你有没有考虑过用phpMyAdmin搭建一个网站?
回答by Eli
mysql-administrator
mysql-管理员
回答by Chris Kloberdanz
There's also MySQL Workbench. It's more for design, but would do what you ask. There's a free version which is a little crippled and I think it might be Windows only.
还有 MySQL Workbench。这更多是为了设计,但会做你所要求的。有一个有点残缺的免费版本,我认为它可能仅适用于 Windows。
EDIT: There is a Linux version.
编辑:有一个 Linux 版本。
回答by BillyWill
Sqlyog community should be fine
Sqlyog 社区应该没问题