MySQL cannot be started after the server is accidentally powered off

When the server is accidentally powered off, the following error occurs when the MySQL database is started: AnotherMySQLdaemonalreadyrunningwiththesameunixsocket. log on to the MySQL database locally.

When the server is accidentally powered off, the following error occurs when the MySQL database is started: Another MySQL daemon already running withthe same unix socket. log on to the MySQL database locally.

An error is reported when the MySQL database is started after the server is accidentally powered off:

Another MySQL daemon already running withthe same unix socket.

When you log on to the MySQL database locally, the following error occurs:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (111)

Cause:

MySQL does not stop normally. After the machine restarts, mysql. sock always exists, but mysql is actually started after the machine is restarted, so you need to set the mysql under/var/lib/mysql. delete the sock file and start it.

This article permanently updates the link address: