What are the alternatives to using phpMyAdmin?

Question

I've used phpMyAdmin for a while now - it gets the job done but it is very clunky and outdated, and has many features that I don't need. I'm looking for either a web based or (preferably) an OS X native alternative that is easy to use and isn't heavy on features.

Is there any programs out there that fit the bill?

Answer 1

For MySQL, CocoaMySQL is pretty good - it concentrates more on database usage rather than server administration.

Answer 2

The OS X port of mysql comes with a native mysql administration gui utility suite called the "MySQL Administrator" and "MySQL Query Browser"

http://www.mysql.com/products/tools/administrator/

http://www.mysql.com/products/tools/query-browser/

Additionally there is a dashboard widget you can install that will monitor the MySQL server performance. It's called MySQLHealth.

Answer 3

MySQL itself has also released a number of tools. One of them is MySQL Administrator. You can also use this in combination with the MySQL Query Browser.

These tools are all cross-platform

Answer 4

I think you will be very impressed with SQL Buddy. That is very similar to phpMyAdmin but with a vastly improved user interface! SQL Buddy is another web interface just like phpMyAdmin. Setup is simply providing a username and password... thats it!

Answer 5

Another useful tool is "SQL Manager Lite for MySQL" from EMS(www.sqlmanager.net). They also have versions for other databases so if you land up using multiple databases (PostgreSQL, FirebirdSQL, MS SQL) this is one way to have a consistent user interface for each database system.

Answer 6

I've used adminer before with some success. It's only a single php file, so very easy to throw on a server when you need it, and easy to remove when you are done, as well.