Error: MySQL Socket Directory Missing

Problem:
When starting MySQL server 5.7.17 with mysqld_safe, the following error occurs:

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

Cause:
The specified directory for the MySQL UNIX socket file does not exist, preventing the server from starting.

Solution:

• Check if the socket path has been modified in the MySQL configuration file (\"my.cfg\").
• If not, manually create the missing directory:

mkdir -p /var/run/mysqld

• Set the appropriate permissions on the directory:

chown mysql:mysql /var/run/mysqld

• Restart the MySQL service.