Mac OS X Server 10.4.3: MySQL Network Connection disabled by default

The "Allow network connections" option is disabled by default in MySQL starting with Mac OS X Server 10.4.3.

Symptom

WebObjects application instances are unable to connect to MySQL. The JDBC connection will fail.

Solution

For Mac OS X Server with Server Tools installed:

1. Go to /Applications/Server.
2. Launch the MySQL Manager application, and stop the MySQL service if it is running.
3. Enable "Allow network connections" by selecting the checkbox
4. Restart the MySQL service.

Note: You need to have administrator privileges to modify the “Allow network connections�? settings.

For Mac OS X Server without Server Tools (headless installation):

1. Edit the file /etc/mysqlManager.plist so that it has "yes" instead of "no" for the key "allowNetwork":
   

   		<key>allowNetwork</key>
   		<string>yes</string>

2. Stop and start the MySQL Service:
   1. Execute this command: sudo SystemStarter stop MySQL
   2. Wait a few seconds and confirm that the service has shut down.
   3. Execute: sudo SystemStarter start MySQL