I do a lot of work on MySQL as part of the CONGO project (oh, and incidentally, as part of my full time job), so I was somewhat stymied when, after my upgrade to Snow Leopard (aka OSX 10.6.0), I was unable to start my local MySQL server – I’d get this:
yacht:~ dbs$ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start Password: Could not find MySQL startup script!
It turns out that as part of the MySQL upgrade, the path to the MySQL installation changed (or a symlink was removed, or something to that effect) – at any rate, /usr/local/mysql no longer existed.
Easy enough to fix, just put a symlink in:
yacht:~ dbs$ cd /usr/local yacht:local dbs$ ls -ldt mysql* drwxr-xr-x 17 root wheel 578 Sep 1 00:31 mysql-5.1.37-osx10.5-x86_64 yacht:local dbs$ sudo ln -s mysql-5.1.37-osx10.5-x86_64/ mysql yacht:local dbs$ ls -ldt mysql* lrwxr-xr-x 1 root wheel 28 Sep 2 12:52 mysql -> mysql-5.1.37-osx10.5-x86_64/ drwxr-xr-x 17 root wheel 578 Sep 1 00:31 mysql-5.1.37-osx10.5-x86_64
After making the symlink, the startup script ran just fine:
yacht:local dbs$ cd /Library/StartupItems/MySQLCOM/ yacht:MySQLCOM dbs$ sudo ./MySQLCOM start Starting MySQL database server yacht:MySQLCOM dbs$ _
I share this to ya’ll for the betterment of geek-kind. 🙂