A powerful management tool for MySQL with similar features to SQL Server Management studio

You should really check SQLYog. It's great, and has a community version.

Quest Toad is good and has pay and free versions for *MySQL.

• free version no longer available

Hate to rain on your parade of tools, but while some of the ones mentioned here are pretty cool, none of them have the mojo of SSMS.

In my MySQL work, I basically switched between SQLYog and MySQL GUI Tools, depending on what I did. SQLYog Enterprise Edition (e.g. the non-free one) also adds support for really basic schema code completion.