你能推荐一个适用于 Linux 的免费轻量级 MySQL GUI 吗？

Can you recommend a free light-weight MySQL GUI for Linux?

提问by Dean Rather

I'm setting up my first development Linux box - a netbook actually. I'm quite fond of MySQL Yog for Windows, but that's not on linux.

我正在设置我的第一个开发 Linux 机器——实际上是一个上网本。我非常喜欢用于 Windows 的 MySQL Yog，但这不是在 linux 上。

I've checked these two threads What is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc…)and Developer tools to directly access databases

我检查了这两个线程 What is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc...)and Developer tools to direct access databases

I'm not interesting in something large and resource hungry (netbook) or that I have to pay for. Nor am I particularly interested in compatibility with SQL.

我对大型且资源匮乏的东西（上网本）或我必须付费的东西不感兴趣。我对与 SQL 的兼容性也不是特别感兴趣。

so, Can you recommend a free light-weight MySQL GUI for Linux?

那么，您能推荐一个适用于 Linux 的免费轻量级 MySQL GUI 吗？

Unless someone suggests something better I'll probably just go with phpMyAdmin.

除非有人提出更好的建议，否则我可能只会使用 phpMyAdmin。

采纳答案by knittl

i suggest using phpmyadmin

我建议使用phpmyadmin

it's definitely the best free tool out there and it works on every system with php+mysql

它绝对是最好的免费工具，它适用于所有带有 php+mysql 的系统

回答by Joshua Partogi

Why not try MySQL GUI Tools? It's light, and does its job well.

为什么不试试MySQL GUI 工具呢？它很轻，并且可以很好地完成工作。

回答by Nick Presta

I really like the MySQL collection of of GUI Tools. They aren't too large or resource hungry.

我真的很喜欢 MySQL 的GUI Tools集合。它们不太大或资源匮乏。

There are quite a few options hereas well. Of the applications presented on that page, I like SQL Buddy - it does require a web server, however.

有相当多的选择在这里为好。在该页面上显示的应用程序中，我喜欢 SQL Buddy - 但是它确实需要一个 Web 服务器。

回答by Sharique

Here are few solutions -

这里有几个解决方案 -

• MySql Gui toolsis official ui from Mysql.
• You can also try Mysql Workbenchwhich is going to replace Gui Tools.
• Mysql Yog can be run on Linux using wine (I think they officially recommend this method).
• HeidiSqlis also good option, I use it most of the time. It also run using wine on Linux. It lightest of all.
• If you are looking for web based solution than phpmyadminis the solution.

• MySql Gui 工具是来自 Mysql 的官方 ui。
• 你也可以试试Mysql Workbench，它会取代 Gui Tools。
• Mysql Yog 可以使用wine 在Linux 上运行（我认为他们官方推荐这种方法）。
• HeidiSql也是不错的选择，我大部分时间都在使用它。它也在 Linux 上使用 wine 运行。它是最轻的。
• 如果您正在寻找基于 Web 的解决方案，那么phpmyadmin就是解决方案。

Since you are already using sqlyog, I suggest you to use same on Linux as well.

由于您已经在使用 sqlyog，我建议您在 Linux 上也使用相同的。

回答by Tom Pa?ourek

Try Adminer. The whole application is in one PHP file, which means that the deployment is as easy as it can get. It's more powerful than phpMyAdmin; it can edit views, procedures, triggers, etc.

尝试管理员。整个应用程序都在一个 PHP 文件中，这意味着部署非常简单。它比 phpMyAdmin 更强大；它可以编辑视图、过程、触发器等。

Adminer is also a universal tool, it can connect to MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch and MongoDB.

Adminer 也是一个通用工具，它可以连接 MySQL、PostgreSQL、SQLite、MS SQL、Oracle、SimpleDB、Elasticsearch 和 MongoDB。

You should definitely give it a try.

你一定要试一试。

You can install on Ubuntu with sudo apt-get install admineror you can also download the latest version from adminer.org

您可以在 Ubuntu 上安装，sudo apt-get install adminer也可以从adminer.org下载最新版本

回答by kboss

RazorSQLfor Linux / Unix.

适用于 Linux / Unix 的RazorSQL。

回答by mjuarez

RazorSQLvote here too. It is not free, but it's not expensive ($70 for a perpetual license and 1 year of free upgrades).

RazorSQL 也在这里投票。它不是免费的，但也不贵（永久许可证 70 美元和 1 年免费升级）。

If you use it for work, it will pay for itself quickly. I was jumping between MySQL GUI tools, SQL Server and Informix DBAccess, some of them through VMs because I use a Mac for development. Having a single tool to connect to any database out there is pretty nice. It is also highly customizable, and very reliable.

如果您将其用于工作，它将很快收回成本。我在 MySQL GUI 工具、SQL Server 和 Informix DBAccess 之间切换，其中一些是通过 VM 切换的，因为我使用 Mac 进行开发。拥有一个连接到任何数据库的单一工具非常好。它也是高度可定制的，并且非常可靠。