scootstah 104 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 post Share on other sites
Philip 123,456,908 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 post Share on other sites
shlumph 5 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 post Share on other sites
premiso 28 Posted January 22, 2013 Share Posted January 22, 2013 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. Link to post Share on other sites
kicken 575 Posted January 23, 2013 Share Posted January 23, 2013 You could go the route of a web-based app also, I like SQL Buddy. Link to post Share on other sites
RobertP 27 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 post Share on other sites
mark_r 1 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. Link to post Share on other sites
jazzman1 91 Posted April 1, 2013 Share Posted April 1, 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... 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. Link to post Share on other sites
jazzman1 91 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 post Share on other sites
Sergei_Kharchenko 0 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 post Share on other sites
anikwa 2 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 post Share on other sites
sathishnadu 0 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 post Share on other sites
DeX 1 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 post Share on other sites
Landslyde 2 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 post Share on other sites
Landslyde 2 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 post Share on other sites
Recommended Posts
Archived
This topic is now archived and is closed to further replies.