14
1
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.
Hannes de Jager
Posted 2010-04-08T19:40:22.987
Reputation: 377
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.
Josiah
Posted 2010-04-08T19:40:22.987
Reputation: 1 662
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 – 2010-04-12T18:09:48.333
Oh I fonrgot to mention that the code completion in SqlYog will also complete the object (tables,columns) names within your database. – Josiah – 2010-04-13T10:40:42.430
5
Tora (Qt client) and Mysql-Workbench (official MySQL client, in GTK) are another alternatives for Linux.
Jaime M.
Posted 2010-04-08T19:40:22.987
Reputation: 660
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). – рüффп – 2012-06-13T06:30:10.943
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.
ChristiaanP
Posted 2010-04-08T19:40:22.987
Reputation: 141
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.
jweede
Posted 2010-04-08T19:40:22.987
Reputation: 6 325
I'm pretty sure Oracle SQL Developer won't work with MySQL – Doug Harris – 2010-04-09T00:58:26.457
heheh. I totally missed that. – jweede – 2010-04-09T02:11:40.647
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 – рüффп – 2012-06-13T06:24:26.303
1
You might find crunchyfrog useful, should you ever have to work with databases other than MySQL.
Ignacio Vazquez-Abrams
Posted 2010-04-08T19:40:22.987
Reputation: 100 516
0
I like runsqlrun -> https://bitbucket.org/andialbrecht/runsqlrun/
This is fork the CrunchyFrog with python3 and gtk3.
Diogo Leal
Posted 2010-04-08T19:40:22.987
Reputation: 21
is code completion the only additional requirement you're looking for? – quack quixote – 2010-04-08T19:46:11.670
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 Jager – 2010-04-08T19:51:56.110