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.
-
is code completion the only additional requirement you're looking for?– quack quixoteApr 8, 2010 at 19:46
-
1The 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 JagerApr 8, 2010 at 19:51
6 Answers
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.
-
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.– JosiahApr 13, 2010 at 10:40
Tora (Qt client) and Mysql-Workbench (official MySQL client, in GTK) are another alternatives for Linux.
-
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
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.
You might find crunchyfrog useful, should you ever have to work with databases other than MySQL.
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.
-
-
-
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
I like runsqlrun -> https://bitbucket.org/andialbrecht/runsqlrun/
This is fork the CrunchyFrog with python3 and gtk3.