How to troubleshoot mysql server startup failure

Failed to start mysql server. View/var/log/mysqld. err

080329 16:01:29 [ERROR] Cant start server: Bind on unix socket: No such file or directory

080329 16:01:29 [ERROR] Do you already have another mysqld server running on socket:/var/run/mysqld. sock?

080329 16:01:29 [ERROR] Aborting

080329 16:01:29 InnoDB: Starting shutdown...

080329 16:01:30 InnoDB: Shutdown completed; log sequence number 0 4646872

080329 16:01:30 [Note]/usr/sbin/mysqld: Shutdown complete

I was puzzled. Later I checked the/var/db/pkg/dev-db/mysql-5.0.56/CONTENTS file, or executed the equery f mysql (the two methods are not applicable to the non-Gentoo Linux release ), I learned that the installation file contains/var/run/mysqld, but this directory does not exist. I recalled that I had cleared the/var/run directory before and thought that the content below was all dynamically created, after the deletion, restart the system. It seems that this is not the case for mysql.

Create this directory and chown it to solve the problem.

# Mkdir/var/run/mysqld

# Chown mysql: mysql/var/run/mysqld