Our mysql service went offline earlier and when we attempted to restart it we were presented with the following error:
System error 2: No such file or directory ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
We checked the mysql config and it is looking in: datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock
but our mysql.sock file is no longer present in /var/lib/mysql/
We tried 'whereis mysql.sock' and it returned: mysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
Several help guides suggested running: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
but /temp/ is empty.
Does anyone know how we might repair this problem please?