Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks.

share|improve this question

8 Answers 8

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

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

Give HeidiSQL a try on Windows.

share|improve this answer

If you're using Mac OS X, I highly recommend CocoaMySQL, available at http://cocoamysql.sourceforge.net/.

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

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

SequelPro for OS X is also nice - http://www.sequelpro.com/

share|improve this answer

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

share|improve this answer

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

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
1  
I hear you - that's why I liked the official Postgres admin tool too. –  Thomas Browne Dec 28 '09 at 14:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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