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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 12:30:23  来源:igfitidea点击:

Mysql Visualization Tools

mysqldatabasedatabase-designvisualization

提问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.

如果这两个是矫枉过正,您可以尝试使用HeidiSQLMySQLFront的后代。它仅在 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 版本。

http://dev.mysql.com/downloads/workbench/5.1.html

http://dev.mysql.com/downloads/workbench/5.1.html

回答by BillyWill

Sqlyog community should be fine

Sqlyog 社区应该没问题