MySQL GUI Tools

I'm definitely late to answer here, but a friend and I were fed up of the overcomplicated Java Swing apps, so we built our own open source SQL editor & Database manager. It's 100% Open source - MIT licensed.

It's really modern compared to many of those listed here, but doesn't have as many advanced features, so it is not as well suited for DBAs, but it's GREAT for regular developers.

Beekeeper Studio

Hope someone else likes using it as much as I do!

dbeaver (https://github.com/serge-rider/dbeaver) is good option aswell, i would disadvice mysql workbench because it is really unstable (on 16.04 and 14.04)

GUI tools that have not been mentioned here, that I know work under Linux without WINE:

• DBeaver http://dbeaver.jkiss.org/ (Java, GPL)
• Squirrel http://www.squirrelsql.org/ (Java, LGPL or GPL)
• ocelotgui https://github.com/ocelot-inc/ocelotgui (C++, GPL)

Disclosure: I work for Ocelot.

I use Adminer. It's very lightweight and with a clear interface.

https://www.adminer.org

Can be installed with sudo apt-get install adminer

But if you want newer versions you should install manually:

https://www.vultr.com/docs/install-adminer-on-debian-ubuntu

One possibility is using SQLExplorer, either as an Eclipse plugin or a standalone "RCP" application. I use it as a plugin, but you can download a Linux standalone version, too. To start the standalone version extract it and execute the sqlexplorer file.

It's being actively developed (last version was in April 2013) and for many people IDE integration is a plus.

I use a free tool Valentina Studio, is FREE, works on 32/64 bit Linux, Windows and Mac OS X. Is the best way to transform your data into meaningful information; create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite databases http://www.valentina-db.com/en/valentina-studio-overview

I solved this problem with the following method (I used to install quanta+ 3.5 in ubuntu 12.04. In the same repositories you can find mysql gui tools):

The tutorial is in this blog article.

Follow the tutorial, and replace:

sudo apt-get install quanta

with:

sudo apt-get install mysql-query-browser mysql-admin

but maybe it is mysql-gui-tools, but i'm not sure.

MySQL workbench does work on Ubuntu 11.xx but it will hang at some of the loading splash screens. You just need to use Alt+F4 to close the splash window and it will continue.

Another alternative is Tora (an opensource Qt multi-platform application).

I know the answer is already accepted but I felt I should add SQLYog to this list anyway since it is such a powerful tool... There is no official build available for Linux but it works quite well on Wine.

I like Emma. Emma is an open source project that isn't developed by Oracle.

Sadly, you can't find these in the Ubuntu Software Centre in later versions of Ubuntu any more. This is because these two pieces of software have reached their end-of-life, and are no longer supported.

---

MySQL Workbench is probably the most complete tool, but a bit sluggish according to me.

I prefer "MySQL Query browser" and "MySQL Administrator". These two can do all basic stuff, and are very user friendly.