I tried creating a soft link to the /usr/local/bin/mysql but that didn't address the issues I was having. However, following a little more research I found a discussion of this problem at:
http://stackoverflow.com/questions/1334272/cant-start-mysql-in-mac-os-10-6-s now-leopard which said: "YOU MUST REINSTALL mySQL after upgrading to Snow Leopard and remove any previous versions as well as previous startup from the preference panel. install 86_64 10.5...I find the others did not work for me." Bummer. However, there was also a discussion suggesting the use of MacPorts: "Have you considered installing MacPorts 1.8.0 (release candidate), and keeping MySQL up-to-date that way? That will build MySQL for the architecture and OS that you're using, rather than installing a 10.5 version on 10.6." I installed MacPorts http://www.macports.org/ (had to reboot) and ran the following commands: sudo port -v self update sudo port list sudo port install mysql5 The MacPort script reinstalled mysql 5 on my Mac and mysql came up properly apparently with everything where it belonged. Pretty slick and almost effortless. Hagen -----Original Message----- From: Hagen [mailto:finha...@comcast.net] Sent: Friday, September 04, 2009 12:24 PM To: mysql@lists.mysql.com Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL I don't appear to have a /etc/my.cnf file - could the upgrade have removed it? Here is the error string I get when I try and start MySQL: finhagens-macbook-pro:bin finhagen$ ./mysqld & [1] 4697 finhagens-macbook-pro:bin finhagen$ 090904 10:25:18 [ERROR] Can't find messagefile '/usr/local/mysql/share/english/errmsg.sys' 090904 10:25:18 [Warning] Can't create test file /usr/local/mysql/data/finhagens-macbook-pro.lower-test 090904 10:25:18 [Warning] Can't create test file /usr/local/mysql/data/finhagens-macbook-pro.lower-test ./mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 090904 10:25:18 [ERROR] Aborting I have noted that a new path was created for mysql during the upgrade: /usr/local/mysql-5.1.31-osx10.5-86/ ...bin ...share ...data etc. Obviously that new path is resulting in the errors above. -What's the best way to inform MySQL the direct structure changed? -Is there a 5.4 version for MAC OS 10.6? -Would it make sense to reinstall with that version? (my data base is tiny and its relatively easy to export and import it and I am the only user) Hagen -----Original Message----- Sent: Friday, September 04, 2009 11:03 AM To: Hagen Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL What is the connect string in the /etc/my.cnf file? -----Original Message----- From: Hagen [mailto:finha...@comcast.net] Sent: Friday, September 04, 2009 9:45 AM To: mysql@lists.mysql.com Subject: MAC OS 10.6 Snow Leopard Breaks MySQL I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find that upgrade appears to have broken MySQL (5.1.31 MySQL Community Server (GPL)). When I attempt to start MySQL I get: ERROR 2002: (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock (2) Has anyone else had this issue and do you know of a fix or work around? Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jgor...@westernwats.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=finha...@comcast.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org