If you are looking for a nice and good database designer for MySQL, then i’m very recommend you to use MySQL Workbench. Beside it is free (GPL License for Community Edition), it is also easy to use. Before i found this, i used to make database designer with other tools or make a hand writing database design (ERD/Entity Relationship Diagram) then i manually make the all tables through PhpMyAdmin. This took a long time.
After i tried MySQL Workbench, i’m very happy about it. It is easy to use. With it’s drag and drop features, i created my database design in a hour. Save my lot of time. I know this tools been a while, but i didn’t know it until i search it. So if you are like me, and read this post, i recommend you to use MySQL Workbench.
“MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench is available as a native GUI tool on Windows, Linux and OS X in different editions.” (From Developer description)
Beside design database, it also have reverse engineering feature. See the complete list of features on their official site.