Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone have any good ideas as to native MySQL GUI clients for Ubuntu?

So far I've tried MySQL Workbench, which never seemed to work properly, phpMyAdmin which I found a bit slow, and Navicat which is a windows port and runs under wine, but none of these is perfect. In an ideal world, I'm looking for something like a native version of navicat.

share|improve this question
MySQL Workbench probably is the only native MySQL GUI Client for Linux. – Marco Ceppi Oct 18 '10 at 19:51
What version of Workbench did you try? A lot of the RC versions were unstable. – Marco Ceppi Oct 18 '10 at 20:31
The thing is, MySQL Query Browser and Administrator are far more friendlier than Workbench. To do simple tasks or very precise ones in Workbench I need to do too many steps. In Query Browser I just open it, go directly to the DB and start working. Same for Administrator. Much more friendlier. I rather use (in my opinion) mysql console than workbench until the actually make it friendlier (And also start working on a .DEB version of 5.5.x and 5.6 instead of only rmp and us having to do many steps to get it working. – Luis Alvarado Dec 1 '11 at 16:15

10 Answers 10

up vote 48 down vote accepted

MySQL Workbench Install 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. Sadly, you can't find them 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.


share|improve this answer
I've been using them for years. Nice, lightweight and useful. – Javier Rivera Oct 19 '10 at 8:07
In my opinion for administrative and DML task phpmyadmin it's a better and easier tool. – neuromancer Nov 4 '10 at 13:24
phpMyAdmin is a very nice tool indeed, but it requires running an HTTP server with PHP enabled. MySQL is not only used for web projects. – W. Goeman Nov 4 '10 at 21:33
Note that MySQL Workbench requires oracle login. – BillMan May 6 '13 at 17:29
some of the most complete tools, but still the market is poor ... Valentina studio is superior in terms of dumping , quick export/import, still both of them have trouble with documented databases ... – decebal Jan 22 '14 at 15:50

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

Install via the software center


share|improve this answer
In Gnome Ubuntu 13.04, Emma crashes often for me. I moved to using Eclipse SQLExplorer as an Eclipse plugin. – Eyal Jun 13 '13 at 13:09
Crashes even more often than MySQL Workbench. – Eduard Luca Sep 17 '13 at 12:12
Works amazingly for me. I love it. Workbench on the other hand is slow and always causing me issues. – Gerry Oct 23 '13 at 6:47
I've been using Emma for years, though it did crash some time ago but not anymore. It's for simple data viewing and minor editing tasks, for something more complex I use and recommend MySQLWorkbench – BlackDivine Mar 10 '15 at 7:54
Awesome! Thats what I want, a light tool because i'm not doing anything too heavy. – Edson Horacio Junior Sep 10 '15 at 12:59

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 enter image description here

share|improve this answer
I use valentina too, switched from WorkBench, but I really find it dificult to run queries in valentina studio ... hangs a lot – decebal Jan 22 '14 at 15:48
They provide deb files that installs perfectly, for both x86 and 64. Tested in Ubuntu 15.04 successfully. – Paulo Coghi Aug 24 '15 at 12:48
I have switched to this over SQLYog. – Nikhil Apr 2 at 0:51

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.

SQLyog Datasearch screenshot

share|improve this answer
Can I also install it and on ubuntu 14.04 Lts ??? – Lykos May 24 '15 at 13:26
Like I said I am not aware of a build for Linux but you can use it with WINE which is a windows emulator on Linux – Nikhil May 27 '15 at 5:15
Do I necessary need WINE too or I can install it without this ? – Lykos Sep 18 '15 at 8:57
@Lykos I think you should ask again if you really really need Wine... dude. – erm3nda Sep 26 '15 at 6:20
Well .. Do I need Wine ? – Lykos Sep 26 '15 at 15:09

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

enter image description here

share|improve this answer
Have you any screen shuts? – shgnInc Dec 29 '13 at 7:38
Tried the current 2.1.3. How to connect to the localhost mysql with this thing? Out of the box that is unclear. "No available connection provider" on Ubuntu 14.04 – Marcos Jan 15 '15 at 9:32

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.

share|improve this answer

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


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

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

share|improve this answer
Hello, yQy, welcome to AskUbuntu! I'm afraid I downvoted your answer. The linked blog article is not in English, and isn't very useful. Furthermore, it's always recommended that answers include the answer, and only provide links for further information. – Flimm Dec 6 '12 at 19:27

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.

share|improve this answer

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

Adminer Sceenshot

Can be installed with sudo apt-get install adminer

But if you want newer versions you should install manually:

share|improve this answer

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

Disclosure: I work for Ocelot.

share|improve this answer

protected by jokerdino Aug 17 '13 at 13:16

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.