views:

3128

answers:

13

I've recently been tasked with developing a web application that will use a MySQL database on the back end. I for most of my career I have worked with MS-SQL Manager. My greatest weakness is in defining foreign key constraints I usually use MS-SQL Manager's diagramming tool to draw my relationship lines between tables.

+5  A: 

You can find the MySQL GUI tools here:

http://dev.mysql.com/downloads/gui-tools/5.0.html

Sean Chambers
+3  A: 

MySQL provides the MySQL Administrator to visual administer and monitore databases as well as the MySQL Query Browser for creating, executing, and optimizing SQL queries on their databases:

Peter Hoffmann
+6  A: 

Not quite a IDE as such but PHPMyAdmin is quite popular.

Vagnerr
A: 

If you're looking for the mySQL equivalent of the SQL server profiler tool, you're out of luck. The db server simply doesn't have the extensive tracing features.

The closest thing I found was this log monitor tool. Basically it monitors your mySQL log and shows it in a scrolling grid view. Useful for figuring out which queries are being executed.

Oh, and I can vouch for the standard MySQL toolkit the others have linked. I use them daily, and they're really useful (and a lot better than phpMyAdmin for more extensive usage).

Erik van Brakel
+7  A: 

If your running on windows you should check out Toad for MySQL http://www.quest.com/toad-for-mysql/

Chris Newman
+5  A: 

A similar question has been asked before: What is the best MySQL Client for Windows?

onnodb
+2  A: 

MYSQL Workbench is a graphic tool for defining database relationships:
http://dev.mysql.com/downloads/workbench/

There is also a SQL Designer that works with a number of databases including MySQL:
http://ondras.zarovi.cz/sql/

Renaud Bompuis
+2  A: 

well, there are many many ides out there ranging from free to darn right take-the-shirt-off-your-back expensive. let me give you my hit list in order of preference

  1. Sqlyog i did some writeup on this one here.
  2. mysql query browser.
  3. mysql workbench.
  4. toad for mysql (with knowledge expert).
  5. embarcadero rapidsql.
  6. sqlmanager for mysql.
  7. navicat for mysql
  8. Altova Databasespy.

this is just a list for those i have either used or still currently use due to specific features they offer.

at the end of the day, after using all the above, not only did i narrow down to sqlyog, but i also paid for the enterprise version because i feel it does everything i would like a gui to do in mysql.

jake
A: 

I like Aqua Data Studio. It costs money but it is elegant and powerful.

Steve McLeod
A: 

I like RazorSQL. Unlike the other tools listed that only support MySQL, it supports pretty much every database you can think of. Why lock yourself into one database?

onunn
A: 

You forgot SQL Maestro for MySQL and AnySQL Maestro (the last product supports almost all possible DBMS and comes in both Freeware and Professional editions).

SQL Maestro Team
A: 

If you're using OS X, Sequel Pro works very well

John T
+2  A: 

HeidiSQL is a simple tool. It's evolving though (previously it was MySQL Front), and it now supports Stored Procedures.

awgtek