Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking at phpMyAdmin to manage users and create the database in the first place. Is it the best thing to go for, or are there other packages that are not web based that might be faster or better? I come from Postgres where pgAdmin III did everything I needed. Is there a free equivalent for MySQL? I am using it on OS X 10.6.2 server. I don't mind paying (a bit) if it's worth it, but I prefer free. It's for a personal server.


share|improve this question

closed as off-topic by HopelessN00b Jan 27 '15 at 0:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 2 down vote accepted

Take a look at Sequel Pro, it's the successor of the good old CocoaMySql.

It's free and open-source and the interface is just great! Give it a try and you will hardly come back!

share|improve this answer

personally i like the official mysql tools best!

Mysql Workbench

quoting from their website:

MySQL Workbench provides DBAs and developers an integrated tools environment for:

  • Database Design & Modeling
  • SQL Development (replacing MySQL Query Browser)
  • Database Administration (replacing MySQL Administrator)
share|improve this answer
I hear you - that's why I liked the official Postgres admin tool too. – Thomas Browne Dec 28 '09 at 14:49

There is Navicat for MySQL Lite edition which is free for non-commercial use if you're looking for a non-web app.

share|improve this answer
thanks I'll play with this too. – Thomas Browne Dec 28 '09 at 14:49
I've used it before. Very similar to the MS Sql Managemenet tool in some aspects. – Chris Dec 28 '09 at 19:23
Navicat is nice, but has its own ideas about character encoding charsets. It appears that the gridview component it uses tries to 'magically' fix incorrectly encoded characters such as utf8 retrieved as latin1. While I actually want it to show the two bytes that make up the utf8 char, it 'fixes' this by showing the single utf8 char. Also, if there's a corrupt character in a record, it displays the record as all blank. As a result Navicat is not fit to debug encoding issues. We use phpmyadmin for that. – Martijn Heemels Jan 1 '10 at 17:12

SQLYog is pretty handy and has both commercial ($$) and community editions.

SequelPro for OS X is also nice -

share|improve this answer

Valentina Studio is available on Windows, Linux and Mac OS X and it is free. It also handles Postgre, SQLite and Valentina DB (an object-relational, columnar db) as well as MySQL.

share|improve this answer

I guess you are searching for something like this: MySQL Workbench

share|improve this answer

If you're using Mac OS X, I highly recommend CocoaMySQL, available at

share|improve this answer
k thanks Jason - but the project has been abandoned. I'll play with its replacement. – Thomas Browne Dec 29 '09 at 0:20

Give HeidiSQL a try on Windows.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.