OS X

Install Apache 2, PHP 5.3, and MySQL 5 with MacPorts, Revisited

A few years back I'd written a few tutorials to get a local PHP and MySQL development environment up and running with MacPorts. Much has changed since then, and while I've updated my development environment, I hadn't bothered to update the tutorials. This post aims to bring things up-to-date.

Install and configure MySQL 5 with MacPorts

7/18/09 - Having trouble starting MySQL on system startup? Rob Wilkerson shows how he gets around the issue.

4/2/08 - UPDATED - Replaced symlink to MySQL socket with proper MySQL configuration file settings. Thanks Doug!

10/20/07 - UPDATED - Added full path to aliases, thanks Joel!

10/7/07 - UPDATED - Clarified +server option and executable names, thanks Thom!

I decided to move my MySQL server installation from the server I installed from MySQL.com to macports. Why? I believe MacPorts will simplify future upgrades. I'd also like to keep my LAMP installs in the same location. If you haven't already, install and configure MacPorts. Here are the steps I'll go over:

  • Intall MySQL 5
  • Create the initial MySQL databases
  • Options for starting MySQL
  • Confirm that MySQL is running
  • Set Basic MySQL Security

Filed under

Firefox 3 Can't Come Soon Enough

I've been a Firefox for Mac user for many years, and before that Mozilla and Netscape. I stuck with Mozilla, despite the release of Safari, because I'd using it for email since Netscape Messenger.

Filed under

To build with package managers, with pre-compiled binaries, or from source... that is the question

I remember how excited I was when Mac OS X was initially released. Finally I had real development tools available on my platform of choice. I could run a web server with middleware to develop database-driven web sites on my laptop. The only problem was that although having Unix file management skills, at the time, I had absolutley no experience compiling the required Unix software from source.

Filed under

Connect to MS SQL Server and Sybase ASE from Mac OS X and Linux with unixODBC and FreeTDS

Although I haven't had need to do so for freelance jobs, I do administer several Windows-based Sybase and MS SQL Servers at my day job.

Filed under