Could someone recommend an easy-to-use frontend for MySQL?

ImranF

New Member
I've used MS's SQL Server and it's attendant tools about 2 years ago, now after a long vacation I've decided to start using MySQL instead.<br />
<br />
While I'm comfortable with command lines, I remember MSSQL Server had this nice frontend which made proofing my SQL statements easier before I committed to actually executing them.<br />
<br />
So, can anyone recommend a similar-looking frontend for MySQL? Preferably freeware or open source, please -- the main reason I'm switching to MySQL now after using MSSQL before.<br />
 

D

New Member
Here you are. This one has worked for me quite well over the years

http//sourceforge.net/projects/heidisql/
 

twopi

New Member
The most common front end for MySQL is phpMyAdmin. If you're running XAMPP or a similar server stack, it's already installed. (It's a web-based PHP app.) It does allow you to work in a more visual sense than the command line, but it's still not as visual as SQL Server.

I also like DbDesigner 4
http//www.fabforce.net/dbdesigner4/index.php
This free tool allows you to draw out your ER diagrams in a free-flowing tool, then synchronize your diagram to a database which it can dynamically build. I feature it in mini-book VI chapter four of HTML / XHTML / CSS All in One for Dummies.
 
Top