Can't connect to local MySQL server through socket

Issue

The following error can be seen in log files:

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

Environment

• CloudLinux OS
• CageFS

Solution

1. Reset MySQL server socket path to default value in the /etc/my.cnf file:
   

   # grep sock /etc/my.cnf
   socket = /var/lib/mysql/mysql.sock

2. Restart mysql or mariadb service

Note: If you have CageFS run:

cagefsctl -M

Cause

MySQL socket file is located in a different place and/or not accessible