Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am not able to start MySQL server on Mac OS X 10.4.11. MySQL was installed using Macports. MySQL was running fine until it suddenly died without any obvious reason.

When running "mysql", I get the error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through 
socket '/opt/local/var/run/mysql5/mysqld.sock' (2)

If I try to start MySQL manually, I get the following error message:

sudo /opt/local/share/mysql5/mysql/mysql.server start
Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line
159: kill: (636) - No such process
ERROR!

In /etc/mysql/my.cnf I have:

socket = __PREFIX/var/run/mysqld/mysqld.sock

But the path "opt/local/var/run/mysqld/" does not exist on my system.

I tried to change the socket path to "__PREFIX/var/run/mysql5/ mysqld.sock" (which is where the socket is located). Unfortunately, this did not help either.

Owner and Permissions for /opt/local/var/run/mysql5/ are correctly set.

Any suggestions on how to start MySQL again? Thanks for your advice.

share|improve this question

2 Answers 2

As frx said, you can download the official distribution for MySQL rather than installing it through ports.

You can also use the wonderfully simple MAMP application to get a MySQL, PHP, and Apache installation all in a neat little self-contained application bundle.

share|improve this answer

take dmg from mysql.com, and start it from pref pane

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.