If you are looking for a nice and good database designer for MySQL, then I’m very recommend you to use MySQL Workbench. Besides it is free (GPL License for Community Edition), it is also easy to use. Before I found this, I used to make database designs with other tools or make a hand-written database design (ERD/Entity Relationship Diagram) then I manually made all the 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 its drag and drop features, I created my database design in an hour. Saved me a lot of time. I know this tool has been around for a while, but I didn’t know it until I searched for 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
Besides design database, it also has a reverse engineering feature. See the complete list of features on their official site.