2

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.

Thomas Browne
  • 93
  • 1
  • 2
  • 14

8 Answers8

6

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)
clamp
  • 175
  • 1
  • 7
3

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

gekkz
  • 4,229
  • 2
  • 20
  • 19
  • 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 01 '10 at 17:12
2

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!

makevoid
  • 158
  • 1
  • 6
1

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.

Lynn
  • 111
  • 1
1

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

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

Andrew
  • 456
  • 3
  • 8
0

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

Raffael Luthiger
  • 2,001
  • 2
  • 17
  • 26
0

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

0

Give HeidiSQL a try on Windows.

Martijn Heemels
  • 7,728
  • 7
  • 40
  • 64