If you've installed mySQL and PHP for creating web-enabled databases, you've probably become quite familiar with the pure UNIX interface to mySQL. For example, you'd type DESCRIBE tablename
for a list of the field definitions in a table; to add a row to a table, the syntax is INSERT INTO tablename (fieldname1, fieldname2) VALUES (expression1, expression2)
. In other words, completely un-Mac-like and non-intuitive ... but quite powerful!
While you can't avoid all of this hassle of the non-GUI interface, there are a couple of tools out there that make managing mySQL databases much easier. The first is an OS X (Carbon) application called MacSQL Monitor
from Runtime Labs. This is a shareware ($40) package that puts a very nice Mac GUI on your mySQL databases. The demo version has limited export capabilities, and will run 10 queries each session.
My personal favorite, though, is phpmyadmin
, from phpwizard.net. This is a collection of PHP scripts designed to help you manage mySQL databases, and it's available free of charge. Through the web-based interface, you can easily create tables, browse records, run queries, modify properties, drop tables, and add/delete entire databases. It's the tool I use when I have to work in the raw database files on the macosxhints website. Read the rest of this article if you'd like an overview of installing myphyadmin.