Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

What MySql client are you using for Linux. I currently use PhpMyAdmin and the Mysql Query Browser but I would like something similar to Toad or HeidiSql that I use on windows. One with SQL code completion.

share|improve this question
    
is code completion the only additional requirement you're looking for? –  quack quixote Apr 8 '10 at 19:46
1  
The more I can get, the better. Basically looking for the best MySql client on linux. I'm a developer, so writing losts of SQL scripts and my databases are getting big. Writing Stored Procedures often also, so anything that will make my life easier. Thanks –  Hannes de Jager Apr 8 '10 at 19:51
add comment

6 Answers

up vote 5 down vote accepted

I use SqlYog running under Wine. This is because quite simply no linux tools that I've found come close to matching the raw power and flexability of SqlYog. This is one of the few non open-source software tools that I use for open source development. Below screenshot shows SQLyog running under Gnome evnironment

share|improve this answer
    
Really looks like a good one. I see Google is also using it. Pity they don't have a native one for Linux, but Wine should do I suppose. –  Hannes de Jager Apr 12 '10 at 18:09
    
Oh I fonrgot to mention that the code completion in SqlYog will also complete the object (tables,columns) names within your database. –  Josiah Apr 13 '10 at 10:40
add comment

I have always prefered Squirrel SQL . Its a universal sql client - so you can use the app to connect to mysql , msSql , Oracle , etc etc.

share|improve this answer
add comment

Tora (Qt client) and Mysql-Workbench (official MySQL client, in GTK) are another alternatives for Linux.

share|improve this answer
1  
+1 for mySQL-Workbench. Even Oracle SQL developer works with 3rd party add-on, this official program works perfectly under linux (RHEL 6 in my case). –  ruffp Jun 13 '12 at 6:30
add comment

You might find crunchyfrog useful, should you ever have to work with databases other than MySQL.

share|improve this answer
add comment

Take a look at this list for Toad from http://alternativeto.net I'm pretty sure Oracle SQL Developer will do what you want on linux.

share|improve this answer
    
I'm pretty sure Oracle SQL Developer won't work with MySQL –  Doug Harris Apr 9 '10 at 0:58
    
heheh. I totally missed that. –  jweede Apr 9 '10 at 2:11
    
In fact there is a third party driver which can be instelled through the SQL Developer Update menu which supports mySQL. I did used it and it was also working –  ruffp Jun 13 '12 at 6:24
add comment

I like runsqlrun -> https://bitbucket.org/andialbrecht/runsqlrun/

This is fork the CrunchyFrog with python3 and gtk3.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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