I want to know what people use for MySQL development. Not so much from the administration side of things (no phpmyadmin) but more on the table creation and schema planning side. I have come across many windows-based IDE's for the creation and development of MySQL databases that were very graphical and useful looking and just trying to get some feedback.
One that nicely integrates UML / database design with administration is what I'm looking for but until then, I'm happy enough without one. I also fear that the limitations of an almost wysiwyg approach will hamper proper database optimisation. Feel free to convince me otherwise, e.g. what do you use, or which is the favourite out of the ones you have tried?
I was hoping someone would have raving reviews for one I haven't discovered yet but here is a list of a few I think look promising: http://www.altova.com/products/databasespy/database_tool.html http://www.mysql.com/products/tools/workbench/ http://www.microolap.com/products/database/mysql-designer/ http://www.fabforce.net/dbdesigner4/ http://www.aquafold.com/index-mysql.html
I used MySQL control center, but it doesn't work well with newer MySQL versions, and it's been discontinued. Then I went back to pen and paper. But if you're looking for a good program to draw out EDs, check out Navicat, It's well worth the money, and will draw out all the DDL for you. I've had a lot of good results with it.