Home / ubuntu / Questions / 8155
Accepted
richzilla
Asked: 2010-10-19 11:35:11 +0800 CST

MySQL GUI Tools

  • 772

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.

software-recommendation mysql

12 Answers

  1. Best Answer

    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.

    Screeshot

    • 68

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

    • 41

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

    • 22

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

    Disclosure: I work for Ocelot.

    • 8

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

    • 6

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

    https://www.adminer.org

    Adminer Sceenshot

    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

    • 5

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

    enter image description here

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

    • 5

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

    enter image description here

    • 4

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

    • 1

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

    • 1