Can some one suggest me good software to get the ER Diagram of a Mysql database? I mean I need to draw the db's table, fields and its dettails.

Tks

If you have access to a Windows box you could
start us MS Access and link in the MySQL tables via ODBC
and then use Access's "Relationships" window to draw
the ERD.

If you install MySQL on a Windows box the ODBC driver is
automatically installed for you, and (I don't know how this
is done!) MySQL databases created on the same machine
are automatically given ODBC DSNs (Data Source Names)
so that linking to them is very easy.

AdoAnywhere has some support for drawing tbales and fields.

www.adoanywhere.com

vanekl, maybe your windows box came with access, but it is not a standard part of the OS...

smartcard, have a look at these data modelling tools

i've heard others mention the Fab4 product (haven't tried it myself, though)

How do I link MS Access to the ODBC MySQL ?
Can you details the steps please ?

[Access Version 10.4302 2002]

Create a database in Access.
Select menu:
File -> Get External Data -> Link Tables...

The 'Link' dialog box will pop up. Choose 'Files of type' ODBC
Databases. The 'Select Data Source' dialog box pops up.
Click on the 'Machine Data Source' tab.
In the 'Data Source Name' column you may see the name
of your MySQL database if the MySQL database is on the
same machine. If you don't see it, you can click on 'New'
and add it. Click 'OK', so that the 'Link Tables' dialog box
pops up next. Click on all of the tables you want to link into
Access, and click the 'OK' button.
You should then see your new table(s) listed in the 'Tables'
view in Access.

To create the ERD, select menu item:
Tools -> Relationships...

You can add tables to the 'Relationships' window by
dragging tables from the main Access database window.
Double-clicking in the Relationships window will allow you to
add a constraint relationship between tables.

Take a look at Embarcadero's ER/Studio.

http://www.embarcadero.com/products/erstudio/index.html

PHPMyAdmin guess that isn't graphical though. DB Designer 4 is pretty good. And it works very well with MySQL.

Donny