MySQL GUI Tools

Question

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.

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 01 '11 at 16:15
Please only recommend one software product per answer, folks! If you want to recommend more than one, post more than one answer. That way, we can upvote each answer separately. — Flimm, Sep 05 '22 at 07:04

score 69 · Accepted Answer · edited Mar 15 '23 at 06:45

69

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

Screenshot

edited Mar 15 '23 at 06:45

Glorfindel

965
3
13
20

answered Oct 18 '10 at 21:15

W. Goeman

1,580
10
12

I've been using them for years. Nice, lightweight and useful. – Javier Rivera Oct 19 '10 at 08:07
In my opinion for administrative and DML task phpmyadmin it's a better and easier tool. – neuromancer Nov 04 '10 at 13:24
4

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 04 '10 at 21:33
Note that MySQL Workbench requires oracle login. – BillMan May 06 '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
@BillMan You are incorrect (at least at time of writing); The link to bypass the oracle account buttons is near the bottom of the page and reads "No thanks, just start my download." – ThorSummoner Dec 24 '14 at 23:08
1

I've stumbled upon this answer because at the moment MySQL workbench is broken in Ubuntu 14.10 https://bugs.launchpad.net/ubuntu/+source/mysql-workbench/+bug/1385147 – Greg Jan 08 '15 at 16:51
The best for me in ubuntu – Luitame Feb 06 '15 at 00:29

score 41 · Answer 2 · edited Sep 05 '22 at 06:58

41

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

Emma is available from the Ubuntu repositories in older versions of Ubuntu. Run:

sudo apt install emma

In newer versions of Ubuntu, Emma is no longer available in the Ubuntu repositories. See this question.

Screenshot

edited Sep 05 '22 at 06:58

Flimm

40,306
22
94
154

answered Oct 18 '10 at 22:19

jet

7,134
1
23
27

In Gnome Ubuntu 13.04, Emma crashes often for me. I moved to using [Eclipse SQLExplorer](http://eclipsesql.sourceforge.net/index.php) 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 06: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 – DivinesLight Mar 10 '15 at 07: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
1

how to start emma after installation? in shell when i type emma, it shows you need to install emboss – sprksh Jan 31 '17 at 06:22
Disadvantage found: when I click on table name, to list table data, emma tries to execute SELECT query. But it forgets to quote table name, so I get a syntax error, since one of my tables name is `function` – Bogdan Burym Jul 24 '17 at 18:10

ahmad dhaybi · Answer 3 · 2013-08-17T13:00:13.923

22

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

edited Aug 17 '13 at 13:00

answered Apr 24 '13 at 20:47

ahmad dhaybi

321
2
3

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
1

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 02 '16 at 00:51
1

Wonderful screen shot that shows the key features on one image. I just looked for design diagrams! – SaidbakR Apr 27 '17 at 19:24
Its a tedious task to get valentina-db for free.The checkout process never completes. – sanjay mundhra Jun 16 '17 at 12:44
also it's not free – chpio Sep 17 '19 at 09:32

score 8 · Answer 4 · edited Sep 05 '22 at 07:00

8

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

DBeaver https://dbeaver.io/ (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.

edited Sep 05 '22 at 07:00

Flimm

40,306
22
94
154

answered Jul 12 '16 at 01:06

Peter Gulutzan

209
2
3

1

No disrespect to you and your team but the UI for ocelot looks absolutely horrid. I mean.. does that software even fall in the same category as all the others? You are suppose to write your own SQL? That is what all the other applications are trying to avoid. Again.. no disrespect, I am sure a lot of effort has been put in the program... but man.. the UI is really really bad – AntonioCS Feb 04 '19 at 11:39
We will not respond to the above because we believe this is not the right forum for arguing about design choices. But feedback is welcome via methods stated in our readme file. – Peter Gulutzan Feb 25 '19 at 20:55
You take what you can get – AntonioCS Feb 26 '19 at 21:09
For many reasons, I will recommend DBeaver. – Saeid Dec 26 '19 at 08:47
It would be much better to have a separate answer for each one of these tools, so we can upvote them separately. – Flimm Sep 05 '22 at 07:00

score 6 · Answer 5 · edited Jul 23 '12 at 06:01

6

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

edited Jul 23 '12 at 06:01

jsist

257
1
2
11

answered Dec 21 '10 at 10:03

Nikhil

249
1
3
8

Can I also install it and on ubuntu 14.04 Lts ??? – ltdev 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 05:15
Do I necessary need WINE too or I can install it without this ? – ltdev Sep 18 '15 at 08:57
2

@Lykos I think you should ask again if you really really need Wine... dude. – m3nda Sep 26 '15 at 06:20
Well .. Do I need Wine ? – ltdev Sep 26 '15 at 15:09
@Lykos - Please have a look at - https://www.webyog.com/product/sqlyog for the install options for SQLYog – Nikhil Dec 24 '15 at 06:46
"Wait, do I really need to be able to read to install this?" - Lykos – David Ljung Madison Stellar Mar 02 '16 at 00:04
I've had endless problems with organising views and doing ODBC (.csv text imports) with SQLYog so I'm moving on. – Eugene van der Merwe Mar 31 '16 at 13:14

score 5 · Answer 6 · answered Jul 23 '20 at 19:43

5

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!

answered Jul 23 '20 at 19:43

Matthew Rathbone

169
1
6

Nice project! It seems, though, that it can't create new databases, which is on of the features I'm looking for. – Paulo Coghi Dec 07 '20 at 10:31

score 5 · Answer 7 · edited Sep 05 '22 at 07:10

I use Adminer. It's very lightweight and with a clear web interface. It's an alternative to phpMyAdmin.

https://www.adminer.org

It can be installed like this:

sudo apt-get install adminer
sudo a2enconf adminer
sudo systemctl reload apache2

Then open http://localhost/adminer

But if you want newer versions you should install manually:

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

Jaime M. · Answer 8 · 2022-09-21T14:55:41.660

4

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

enter image description here

edited Sep 21 '22 at 14:55

answered Dec 01 '11 at 11:01

Jaime M.

380
4
13

Have you any screen shuts? – shgnInc Dec 29 '13 at 07: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 09:32
The website says "Look At Front Doors", it looks like it's no longer for this software project. Is it dead? – Flimm Sep 05 '22 at 07:03
I have updated the link to the github project. – Jaime M. Sep 21 '22 at 14:56

score 1 · Answer 9 · edited Nov 09 '12 at 12:52

1

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.

edited Nov 09 '12 at 12:52

Oyibo

1,909
5
23
40

answered Dec 01 '11 at 15:54

scottfennell

21
1

score 1 · Answer 10 · answered Dec 22 '17 at 15:46

1

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)

answered Dec 22 '17 at 15:46

Wouter

291
1
5

score 0 · Answer 11 · edited Dec 06 '12 at 17:43

0

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.

edited Dec 06 '12 at 17:43

answered Dec 06 '12 at 17:16

yQy

11

3

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 06 '12 at 19:27

score 0 · Answer 12 · answered Jun 13 '13 at 15: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.

MySQL GUI Tools

12 Answers12

Linked

Related