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

Please log in using one of these methods to post your comment:

WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s