mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists

mysql sockets
Rajadip picture Rajadip · Feb 10, 2017 · Viewed 204.5k times · Source

While starting mysql server 5.7.17 using mysqld_safe, following error occcours.

2017-02-10T17:05:44.870970Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2017-02-10T17:05:44.872874Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2017-02-10T17:05:44.874547Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.

How to fix it ?

Answer

Matt Clark picture Matt Clark · Feb 10, 2017

It seems odd that this directory was not created at install - have you manually changed the path of the socket file in the my.cfg?

Have you tried simply creating this directory yourself, and restarting the service?

mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld

Related questions

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I am getting the following error when I try to connect to mysql: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Is there a solution for this error? What might be the reason behind …

Read More
centos: Another MySQL daemon already running with the same unix socket

I have a strange error when starting mysqld service: Another MySQL daemon already running with the same unix socket. I've tried to list running services and stopping them but the same error happens when starting mysqld service. I can try …

Read More
Cannot find mysql.sock

I just had to re-install mysql and I am having a problem starting it up. It cannot find the socket (mysql.sock). The problem is that neither can I. In my Mac OS X 10.4 terminal, I type: locate mysql.sock, …

Read More