Many users who installed the GoLive Preconfigured Servers and MySQL on Mac OS X 10.1.x found that MySQL was broken after they upgraded to Mac OS X 10.2. If you run the Start MySql script and get an error message as seen below in Figure 5.1 then you need to fix your MySQL installation under OS X 10.2. The good news is that it’s very easy and this step-by- step tutorial will walk you through the process.

When you installed MySQL under Mac OS X 10.1.x you had to create a user account called mysql so MySQL could run properly. Now with Mac OS X 10.2, Apple conveniently includes a default mysql user in the system so you no longer need to create that user account yourself. The problem addressed in this tutorial only arises when you install MySQL under Mac OS X 10.1.x and then upgrade to Mac OS X 10.2 because the standard user account created on the machine for MySQL is hijacked or overwritten by a Netinfo only user account of the same name. Bascially, we’ll just delete the Netinfo user in Netinfo Manager and recreate the standard user account.

Step 1: Locate and launch the NetInfo Manager Application
Find the NetInfo Manager application in your Applications/Utilities folder and launch it by double-clicking. The application icon looks like the one in Figure 5.2….

Download pdf for Fixing MySQL after upgrading to Mac OS X 10.2