msyql启动错误Another MySQL daemon already running with the same unix socket.

来源:互联网 发布:windows10推荐必备软件 编辑:程序博客网 时间:2024/06/02 07:15

在Linux上安装完成mysql并启动时,出现如下的错误:

Another MySQL daemon already running with the same unix socket.

可以通过如下的方法进行解决:

原因多个Mysql进程使用了同一个socket。

两个方法解决:

第一个是立即关机 使用命令 shutdown -h now 关机,关机后在启动,进程就停止了。

第二个直接把mysql.sock文件改名即可。也可以删除,推荐改名。

然后就可以启动mysql了。

下面是国外原文

To prevent the problem from occurring, you must perform a graceful shutdown of the server from the command line rather than powering off the server.

shutdown -h now

This will stop the running services before powering down the machine.
Based on Centos, an additional method for getting it back up again when you run into this problem is to move mysql.sock:
# mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
# service mysqld start

Restarting the service creates a new entry called mqsql.sock

若第一次通过第二种方式解决并且mysql可以正常运行后,此时关闭掉了机器,然后启动mysqld服务时,又出现了同样的错误的话,此时可以把mysql.sock.bak删除,然后重新执行命令

mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak,即可


0 0