Adding Perl support for MySQL on Mac OS X part 2

I’ve been working on it, and it seems it is not as difficult as it was last year! We’ll start with the easy bits:

Download and install MySQL

This is fairly easy, go to the MySQL website, and follow the link ‘downloads’. Choose the ‘Generally Available (GA) release (recommended)’ version (at the moment this is MySQL 5.0), and follow that link. On the next page, scroll down untill you reach the section with ‘Mac OS X downloads’, and download the version that is suitable for your system and OS.

After the download is complete, doubleclick both packages and follow the instructions on the screen. You can also doubleclick ‘MySQL.prefpane’, which will install a small pane in your System Preferences, but this is less useful if you install ‘MySQL Administrator’; this pane can only stop and start the MySQL server, and force it to start when your Mac boots.

Download and install PHP

PHP you ask? Well yes, sometimes it can be handy to have PHP installed also, so we will do just that! Go to the official PHP website, again follow the link ‘downloads’. Under ‘Binaries for other systems’ (on the left), you will find Mac OS X. Follow that link, and search on this page for the heading ‘PHP 5 on Mac OS X 10.3/10.4′ (or later versions of Mac OS X when thay are available). Mac OS X Panther and Tiger come with Apache 1.3, so you need ‘PHP 5.0.4 for Apache 1.3′ (or higher if available); click on it and download the package. Again, mount the downloaded diskimage, doubleclick the package and follow the instructions on the screen. PHP is now available in Apache.

Download and install MySQL utilities

A handy utility that gives a lot of information about the MySQL server and databases is MySQL Administrator. On this page, follow the ‘Download Binaries & Source’ link (on the right side of the page), choose the version suitable for your system, and then choose the Mac OS X version.

Another utility that I found very convenient was CocoaMySQL, nice interface, and handy to inspect the contents of the databases, but it didn’t work quite as it should when I installed it under Tiger, but you can try it anyway.

Leave a Reply