Are there any GUIs for Mysql? What is recommended? [duplicate]

Solution 1:

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

MySQL Query Browser

enter image description here

Good luck!

Solution 2:

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

Solution 3:

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.

Solution 4:

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.