I use phpmyadmin and find it adequate for most purposes, however I use greasemonkey to enhance various aspects. Here are a number of such scripts, you can of course write one on your own. Another alternative is HeidiSQL. This is a Windows-only ® app but runs pretty well using Wine. Then there is MySQL Workbench which has been mentioned in other posts. I don't find its query capabilities as fluid as phpmyadmin but generating ERD with it and synchronising with the database is pretty slick.
是的！ Linux 下的 MySQL Workbench 的最新版本比 Sequel Pro 更好。
使用 MySQL Workbench，您可以轻松查询、导出数据为 csv 等格式、编辑表数据。里面有查询指南。您可以同时看到模式列表、表列表、每个表的列、查询框和查询结果。
Yes! The last version of MySQL Workbench, in linux, is better than Sequel Pro.
With MySQL Workbench you can easily query, export data as csv and other formats, edit table data. It has a query guide inside. You can see the schema list, the table list, the columns for each table, the query box and the query result, everything at the same time.
vStudio on linux or windows. I did have some problems with it crashing on linux but just updated to the latest version and it seems to run ok. It has a nice query editor and allows you to save your servers and projects. It is the best I have found so far.
Navicat is a paid client. I have only used it once but it fell short of expectations.
I recommend phpmyadmin or mysql workbench is best for any kind of DB GUI.
To setup phpmyadmin click here for complete guide.
To download mysql workbench you can simple go in ubuntu software and search mysql workbench and install it. You can click here to download complete offline installer for mysql workbench according to your OS. By terminal you have to follow these steps click here
发布评论
评论（10）
据我所知，有一些不同的选项，具体取决于您运行它的平台。您可以使用以下命令：
There are a few different options that I know of, depending on the platform you are running it on. You could use the following:
MySQL Workbench 是一个很棒的跨平台工具。用户界面可能看起来不像 Sequel Pro 那样流畅，但它提供的功能已经足够好了。
MySQL Workbench is a great and cross platform tool. The UI might not look as slick as Sequel Pro but the features it provides are good enough.
我使用 phpmyadmin 并发现它足以满足大多数用途，但是我使用greasemonkey 来增强各个方面。 这里有很多这样的脚本，您当然可以自己编写一个。< br>
另一种选择是 HeidiSQL。这是一款仅限 Windows® 应用程序，但使用 Wine 运行得非常好。
然后是MySQL Workbench，在其他帖子中已经提到过。我发现它的查询功能不像 phpmyadmin 那样流畅，但用它生成 ERD 并与数据库同步非常流畅。
I use phpmyadmin and find it adequate for most purposes, however I use greasemonkey to enhance various aspects. Here are a number of such scripts, you can of course write one on your own.
Another alternative is HeidiSQL. This is a Windows-only ® app but runs pretty well using Wine.
Then there is MySQL Workbench which has been mentioned in other posts. I don't find its query capabilities as fluid as phpmyadmin but generating ERD with it and synchronising with the database is pretty slick.
是的！ Linux 下的 MySQL Workbench 的最新版本比 Sequel Pro 更好。
使用 MySQL Workbench，您可以轻松查询、导出数据为 csv 等格式、编辑表数据。里面有查询指南。您可以同时看到模式列表、表列表、每个表的列、查询框和查询结果。
Yes! The last version of MySQL Workbench, in linux, is better than Sequel Pro.
With MySQL Workbench you can easily query, export data as csv and other formats, edit table data. It has a query guide inside. You can see the schema list, the table list, the columns for each table, the query box and the query result, everything at the same time.
我推荐TablePlus：
tableplus.com
I recommend TablePlus:
tableplus.com
Linux 或 Windows 上的 vStudio。我确实遇到了一些问题，它在 Linux 上崩溃，但刚刚更新到最新版本，它似乎运行正常。它有一个很好的查询编辑器，允许您保存服务器和项目。这是迄今为止我发现的最好的。
Navicat 是付费客户端。我只用过一次，但没有达到预期。
vStudio on linux or windows. I did have some problems with it crashing on linux but just updated to the latest version and it seems to run ok. It has a nice query editor and allows you to save your servers and projects. It is the best I have found so far.
Navicat is a paid client. I have only used it once but it fell short of expectations.
试试 sqlyog，太棒了，社区版是免费的。
try sqlyog, awesome and the community edition is free.
phpMyAdmin 非常简单且标准。因为它是基于网络的，所以不需要安装。
phpMyAdmin is pretty simple and standard. Because it is web based, no installation required.
我推荐 phpmyadmin 或 mysql workbench 最适合任何类型的数据库 GUI。
要设置 phpmyadmin 单击此处 获取完整指南。
要下载mysql workbench，您可以简单地进入ubuntu软件并搜索mysql workbench并安装它。您可以点击此处根据您的操作系统下载mysql workbench的完整离线安装程序。通过终端，您必须按照以下步骤单击此处
I recommend phpmyadmin or mysql workbench is best for any kind of DB GUI.
To setup phpmyadmin click here for complete guide.
To download mysql workbench you can simple go in ubuntu software and search mysql workbench and install it. You can click here to download complete offline installer for mysql workbench according to your OS. By terminal you have to follow these steps click here
我在 wine 下使用 SQLyog
我认为 SQLyog 有一个很好的功能，不如 mysql workbench 但快得多，
付费版本可能更好
im using SQLyog under wine
i think SQLyog have a good feature, not as much as mysql workbench but much faster
the paid version maybe even better