MySQL 5.5.8 can’t start automatically on Mac OS 10.6.6

After resolving the problem of MySQL and mysql gem I got another problem: MySQL 5.5.8 didn’t start automatically when I boot my computer.

Don’t be serious, you can fix it easily by modifying mysql.server file.
Open /usr/local/mysql/support-files/mysql.server with your favorite text editor, locate the configuration of basedir= and datadir=, change them to:

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

and the problem gone, your MySQL server now starts automatically everytime you boot the computer.

now you can start the MySQL server manually (no need to reboot) by this command:

gnguyen:var gnguyen$ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
Starting MySQL database server
gnguyen:var gnguyen$

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s