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
