Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

Possible Duplicate:
MySQL GUI Tools

I am looking for a mysql GUI for ubuntu 11.04.

I am looking for one with a feature set comparable to sqlyog for windows.

Does anyone have any recommendations?

I have tried

And hated them both...

share|improve this question

marked as duplicate by Eliah Kagan, Anwar Shah, hbdgaf, jokerdino, Mitch Jul 23 '12 at 6:26

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

9 Answers 9

up vote 4 down vote accepted

I run the SQLyog Community Edition in wine. It's got a reduced feature-set though, so it might be missing what you like from the commercial version. But you should be able to run the commercial version in wine too.

SQLyog data search screen shot

share|improve this answer

Give a try to MySQL Administrator, this GUI tool is succeeding in all the tasks that I have performed to the date. I am also using MySQL Query Browser. Both them can be found in Synaptic in Ubuntu 10.10 and I have notices that they are also in 11.04

Please inform how did you do with this suggestion as I am going to move to 11.04 and I will really appreciate if you drop a message with your experiences on this, so I can have a preview of what am I going to face.

I am following your question closely.

Screenshots here:

MySQL Administrator

enter image description here

enter image description here

MySQL Query Browser

enter image description here

Good luck!

share|improve this answer
1  
+1 This tool works very well and makes it very easy to add / remove users, edit permissions, etc. –  Nathan Osman Apr 19 '11 at 0:13
    
I will give +1 when i the vote time resets. For me the Gui Tools are MUCH MORE friendlier than the Workbench hell. Workbench has very good things but a human friendly approach is not one of them. –  Luis May 31 '11 at 15:28
    
Thank you @CYREX, I am with you about GUI's. Even when the powers of MySQL can be exploded more efficiently in a Workbench, a GUI is a fast way to achieve even complicated tasks, and not all we are professionals on workbenching, or -in my personal case- I don't need further, everything is covered in the GUI. –  Geppettvs D'Constanzo May 31 '11 at 17:37
    
These were replaced by MySQL when they released the Workbench, and are now considered obsolete and unsupported (it even says that on MySQL's site) –  Thomas W. Jul 12 '11 at 18:35
    
This is the way to go! +1 from me too! –  Rinzwind Jul 12 '11 at 18:35

Hate Mysql Workbench all you want, but when it comes to

  • Mysql
  • GUI
  • Open Source
  • Linux

the Workbench is the way to go. If you are using an IDE like Eclipse or Netbeans you might find the Mysql-Plugins there to be acceptable too, but for the above mentioned parameters that's pretty much it.

share|improve this answer

I often rely on phpMyAdmin, as it gives an easily configurable external interface, and has most of the tools I've found in other programs.

share|improve this answer
    
One of the features I use quite often is connecting to the local, testing, and production servers at the same time. I then sync the schema from my localhost with both the production and testing server. I then copy the data from production to my local and testing servers. –  Hailwood Apr 18 '11 at 23:42
    
As far as I am aware phpmyadmin can only connect to a single database? It also does not support schema sync. –  Hailwood Apr 18 '11 at 23:44

The most comprehensive database manager I've used is Navicat due to the fact it supports lots of different databases and allows you to connect to multiple servers. For general day-to-day use I still find phpmyadmin is the most efficient at getting things done.

share|improve this answer

I tried a few different MySQL apps and settled on Emma (from the repos). Its not particularly pretty but for me its simple to understand and does everything I need it to.

The only confusing thing is it won't fill in the port automatically when you set up a new connection (default is 3306).

share|improve this answer

try sidu for mysql, postgres and sqlite:

http://sidu.sf.net

share|improve this answer

DBeaver..

I have using this tool for a month.. great tools to manage my database from MySQL, Oracle and another database.. :)

Support for Windows, MacOS, and Linux ;-

http://dbeaver.jkiss.org/download/
share|improve this answer

I didn`t find any good native Linux Mysql client, too.

Navicat is really very handy and powerful client, in the official site you can find free "Linux versions". But if you will download it, you will see that in fact it is Windows executable with preconfigured Wine :). But it works pretty good.

Another good Windows client is HeidiSQL. It is active open-source project written in Delphi. Client have a lot of useful functions like filtering records, exporting and importing data. It works quite good in Wine, but I faced some bugs with GUI (e.g. ugly toolbar icons).

share|improve this answer

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