I've been running into some problems with MySQL Workbench that I'm not sure will be able to be fixed (namely, what appears to be an old bug that may have resurfaced), so I'd like to be able to find a good backup to it in the event that I can't use it. I've sifted through several suggested alternatives, such as Navicat (Navicat is not free for business use, it only has a 30-day trial), but none of them have satisfactorily met my current requirements.
What I need:
- Linux compatible (preferably Linux native, I'm using Ubuntu)
- Able to connect to remote databases via SSH tunneling
- Free and/or Open Source (I currently don't have the funds to shell out $100+ for a product and would rather support a good Open Source project, anyway)
- An interface at least as good a Workbench's (it could just be because I'm used to it, but I like its interface, very clean and rather intuitive tabbed interface; doesn't have to be identical, though)
- Supports MySQL 5+
While it's nice to have, I don't need the extra data modeling stuff that Workbench has. I also don't need fancy GUI stuff (query designers and the like). A way to view the data in an orderly manner and a place to edit queries is really all I need.
I'm currently checking out HeidiSQL, but it reminds me of something I used to use when I was running Win9x/Win2k, only runs through WINE, has crashed on me once already, and just overall feels clunky, though I do like its easy ability to dump a database or do changes to multiple tables.