Does anyone know a good (preferably open source and cross platform) tool to allow simple visualization of mysql databases? I just need a tool I can quickly point at a database and it’ll show basic table structure and field types, etc. Nothing too advanced or crazy.
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
MySQL Workbench runs on Windows and Linux. The commercial version will let you reverse engineer and edit the stucture of a live database, with the free one you have first to dump the structure to a file. Its ancestor DBDesigner is a bit older, but doesn’t have this limitation. Windows and Linux too.
If these two are overkill you may try with HeidiSQL, the descendant of MySQLFront. It runs on Windows only, but there is an alpha version running on Java.
Method 2
I really like Sqlyog on Windows. It is (technically) open source, but not cross-platform. (Scroll down to “community edition”)
If your requirements are open source, simple, and cross-platform, hav eyou considered setting up a website with phpMyAdmin?
Method 3
mysql-administrator
Method 4
There’s also MySQL Workbench. It’s more for design, but would do what you ask. There’s a free version which is a little crippled and I think it might be Windows only.
EDIT: There is a Linux version.
http://dev.mysql.com/downloads/workbench/5.1.html
Method 5
Sqlyog community should be fine
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0