MySQL Daemon Lock issue

mysql sockets debian
SamboyCoding picture SamboyCoding · Jan 22, 2016 · Viewed 45.7k times · Source

Last night, my MySQL server went down unexpectedly. On attempting to restart (with service mysql restart - I'm root) it merely hangs. With the mysql -u root -p command, I get:

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

I then tried to start the daemon manually (mysqld). The prompt would hang for about 2 seconds, and then return. On closer inspection of the error logs, I got:

2016-01-22T19:18:32.399584Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.

2016-01-22T19:18:32.399622Z 0 [ERROR] Unable to setup unix socket lock file.

2016-01-22T19:18:32.399646Z 0 [ERROR] Aborting

I then tried chown mysql /var/run/mysqld, chmod -R 775 /var/run/mysqld and apt-get install mysql-community-server --reinstall. No luck.

I have looked around, and couldn't find a solution. Any help here?

Note: I am Running Debian 8 (Jessie) with MySQL community Server 5.7.10

Answer

jorfus picture jorfus · Oct 16, 2017

I just ran into this. The mysql install was a little weird and was missing /var/run/mysqld/

MySQLd was attempting to create the socket and lock file but the parent directory was missing. I simply created the directory

sudo mkdir /var/run/mysqld

chowned it to mysql

sudo chown mysql:mysql /var/run/mysqld

I was then able to start mysqld normally.

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
mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists

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-10…

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