List:General Discussion« Previous MessageNext Message »
From:Hagen Date:September 5 2009 3:46pm
Subject:MAC OS 10.6 Snow Leopard Breaks MySQL - Resolved
View as plain text  
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:finhagen@stripped] 
Sent: Friday, September 04, 2009 12:24 PM
To: mysql@stripped
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:finhagen@stripped] 
Sent: Friday, September 04, 2009 9:45 AM
To: mysql@stripped
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=1


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
how to get the time of the client in sleep statusstutiredboy4 Sep
  • Re: how to get the time of the client in sleep statusClaudio Nanni4 Sep
    • MAC OS 10.6 Snow Leopard Breaks MySQLHagen4 Sep
RE: MAC OS 10.6 Snow Leopard Breaks MySQLHagen4 Sep
  • MAC OS 10.6 Snow Leopard Breaks MySQL - ResolvedHagen5 Sep