Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Running MySQL on OS X Lion Server

Hello together,


I have OS X Lion Server wich was upgraded from Leopard Server.


Now I want to run the MySQL Server.


/usr/bin/mysqld_safe --user=mysql &


produces this error in thte file

/var/mysql/<hostname>.err


21218 19:39:41  mysqld started
121218 19:39:41 [Warning] Setting lower_case_table_names=2 because file system for /var/mysql/ is case insensitive
121218 19:39:42  InnoDB: Started; log sequence number 0 43655
121218 19:39:42 [ERROR] Can't start server : Bind on unix socket: Invalid argument
121218 19:39:42 [ERROR] Do you already have another mysqld server running on socket: /var/mysql/mysql.sock ?
121218 19:39:42 [ERROR] Aborting
121218 19:39:42  InnoDB: Starting shutdown...
121218 19:39:43  InnoDB: Shutdown completed; log sequence number 0 43655
121218 19:39:43 [Note] /usr/libexec/mysqld: Shutdown complete


Definitley there ist no mysql server running at all.


After all I decided to delete the contents of /var/mysql and to run


mysql_install_db --user=mysql


But this didn't change anything.


This is the content of my /etc/my.cnf file:


[client]
socket=/var/mysql/mysql.sock
[mysqld]
socket=/var/mysql/mysql.sock


Can anyone give me some advice on how to get MySQL runnning?


Thanks in advance

macmartin

OS X Server

Posted on Dec 18, 2012 10:52 AM

Reply
Question marked as Best reply

Posted on Dec 18, 2012 11:22 PM

Well, the obvious question is what the permissions on /var/mysql and /var/mysql/mysql.sock are.


What you have is a classic permissions issue. it doesn't necessarily indicate anything wrong with MySQL, per se.

2 replies

Dec 20, 2012 10:16 PM in response to Camelot

Hello Camelot,


thank you for your reply.


I also thought it could be a permissions problem, but permissions seemed to be all right


A few days ago I even tried:

sudo chmod -R 777 /var/mysql


After all I found there wer ACL entries on /var/mysql and the files in it.

Removing these solved the problem


Thank you very much.


Best regards from Germany

macmartin

Running MySQL on OS X Lion Server

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.