scootstah Posted January 22, 2013 Share Posted January 22, 2013 MySQL Workbench works fine in Windows, but it's a heap of crap in Ubuntu. You can't select multiple data rows, it's slow, it crashes every 5 minutes... Is there a good alternative? I like the functionality and features that MySQL Workbench offers, but I need something a bit more stable. The features I'm looking for are: - Connect via SSH Tunnel - A nice query executor - Able to save SQL snippets (not so important, but nice) What do you guys use? Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/ Share on other sites More sharing options...
Philip Posted January 22, 2013 Share Posted January 22, 2013 I use MySQL workbench, mainly on windows. It's not the best that's for sure. I'm interested in seeing other options as well. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1407506 Share on other sites More sharing options...
shlumph Posted January 22, 2013 Share Posted January 22, 2013 Can't say I've ever tried it under Ubuntu, but NetBeans has MySQL support: http://netbeans.org/kb/articles/mysql.html (old article, but you can catch the drift from the videos) I'm pretty sure Eclipse has MySQL integration too. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1407523 Share on other sites More sharing options...
premiso Posted January 22, 2013 Share Posted January 22, 2013 (edited) I use bash I know of http://sourceforge.net/projects/mysqlcc/ which works decent. The workbench I just hated. The MySQLCC program was the best I found, but I still prefer to use the CLI. Edited January 22, 2013 by premiso 1 Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1407525 Share on other sites More sharing options...
kicken Posted January 23, 2013 Share Posted January 23, 2013 You could go the route of a web-based app also, I like SQL Buddy. 1 Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1407609 Share on other sites More sharing options...
RobertP Posted January 24, 2013 Share Posted January 24, 2013 had the same question a few months ago, and i just installed the newest version of phpmyadmin and have not looked back. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1407861 Share on other sites More sharing options...
mark_r Posted April 1, 2013 Share Posted April 1, 2013 You can use Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview. Works on Linux, Mac and Win. 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Includes not only db management but powerfull reports that work again on 3 OS. 1 Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1422258 Share on other sites More sharing options...
jazzman1 Posted April 1, 2013 Share Posted April 1, 2013 (edited) MySQL Workbench works fine in Windows, but it's a heap of crap in Ubuntu. You can't select multiple data rows, it's slow, it crashes every 5 minutes... Hm..... that's very weird. I've never have a problem with it for one year on my CentOS6.x (Gnome) machine. I thing that problem appears because of yours linux graphical environment. Edited April 1, 2013 by jazzman1 Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1422267 Share on other sites More sharing options...
jazzman1 Posted April 1, 2013 Share Posted April 1, 2013 I don't know why you cannot retrieve the content from multiple tables and databases. Unfortunately, there is no way to test it how this wonderful program works in windows ( I have only windows 95) See my log, the last time that I restarted the mysql-workbench was at March 28. Log: [jazzman@localhost log]$ ps aux | grep /usr/bin/mysql-workbench jazzman 31356 0.0 0.0 106096 1276 ? Sl Mar28 63:27 /bin/bash /usr/bin/mysql-workbench jazzman 32504 0.0 0.0 103244 844 pts/0 S+ 12:57 0:00 grep /usr/bin/mysql-workbench Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1422287 Share on other sites More sharing options...
Sergei_Kharchenko Posted July 12, 2013 Share Posted July 12, 2013 I don't think that MySQL WorkBench is very good for Windows... Read the article about its more professional and functioonal alternative: http://blogs.devart.com/dbforge/mysql-workbench-worthy-alternative-dbforge-studio-for-mysql.html So for Windows I use dbForge Studio for Mysql ( http://www.devart.com/dbforge/mysql/studio/ ), and for Linux I prefer Valentina ( http://www.valentina-db.com/en/valentina-studio-overview ) Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1440432 Share on other sites More sharing options...
anikwa Posted November 27, 2013 Share Posted November 27, 2013 I've not had any issues with MySQL Workbench in either Windows or Linux. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1460416 Share on other sites More sharing options...
sathishnadu Posted March 14, 2014 Share Posted March 14, 2014 i have used SQLyog for this. But it uses wine. The UI is very intutive. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1472580 Share on other sites More sharing options...
DeX Posted June 29, 2015 Share Posted June 29, 2015 I've been using Workbench in Ubuntu for years without any problems at all, it hasn't crashed once. Another alternative you can try is Squirrel SQL, I know that also works for Microsoft SQL databases as well. I used it on a previous Microsoft project and it worked great but I still prefer Workbench for non-Microsoft databases. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1515238 Share on other sites More sharing options...
Landslyde Posted February 9, 2016 Share Posted February 9, 2016 I use Adminer for MySQL / MariaDB. Very intuitive. Nice, clean interface. And it comes with a slew of skins to fit personal preferences. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1530900 Share on other sites More sharing options...
Landslyde Posted February 9, 2016 Share Posted February 9, 2016 I tried to edit the above post, but I wasn't "authorized" for that. I misread. Adminer is web-based. The Linux GUI I use for MySQL / MariaDB is JPDB Admin. There's a FREE edition and one for $15. Not a bad way to go. Link to comment https://forums.phpfreaks.com/topic/273491-linux-gui-for-mysql/#findComment-1530901 Share on other sites More sharing options...
Recommended Posts