14

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.

2
  • is code completion the only additional requirement you're looking for? Apr 8, 2010 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 Apr 8, 2010 at 19:51

6 Answers 6

5

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

2
  • 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. Apr 12, 2010 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, 2010 at 10:40
5

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

1
  • 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).
    – рüффп
    Jun 13, 2012 at 6:30
4

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.

1

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

1

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.

3
  • I'm pretty sure Oracle SQL Developer won't work with MySQL Apr 9, 2010 at 0:58
  • heheh. I totally missed that.
    – jweede
    Apr 9, 2010 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
    – рüффп
    Jun 13, 2012 at 6:24
0

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

This is fork the CrunchyFrog with python3 and gtk3.

Not the answer you're looking for? Browse other questions tagged .