Is there any er diagram tool in Windows that I can use to connect to a MySQL 4.1 database in Unix?

Question

I have a few test databases in some Unix SUSE 8 servers and initially the plan was to find some tools which can directly create the ERD straight from the server until someone told me that I can find tools to connect from the Windows PC straight to the Unix MySQL database.

So I saw MySQL query analyzer which can do this but unfortunately there are no options to create an ERD. So are there any tools, preferably open source or free which can do this?

I've done some basic googling but didn't know what is the exact terms to use to search for this and have so far found nothing useful yet.

Updates:

I just found out that the latest version of workbench doesn't work MySQL 4.1 Enterprise Edition which is the version that I have!

And I try to use fabFORCE DBDesigner but I can't even connect at all using that one :( What can work for this version of MySQL?

Answer 1

DBDesigner will do for MySQL 4.1.

This tool is the predecessor of MySQL Workbench. From my practical experience DBDesigner is a handy and user-friendly but so-so reliable tool (so save often!)

Answer 2

Aqua data studio can do that, IMO pretty well.

Answer 3

The fact that the server is running in another platform is entirely irrelevant. It's MySQL, you talk MySQL and the MySQL Server will read you, the rest are details.

About the tool, I like the MySQL GUI Tools package and MySQL Workbench, it's all you need to manage your MySQL stuff.