MYSQL启动异常：Can 't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '(2) "

最新推荐文章于 2024-07-25 09:51:34 发布

李小西033

最新推荐文章于 2024-07-25 09:51:34 发布

阅读量2.9k

点赞数

分类专栏： MYSQL

本文链接：https://blog.csdn.net/lissdy/article/details/23970571

版权

MYSQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

一次异常关机之后，再次启动mysql服务，报出异常Can 't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '(2) "。
之前在服务器上遇到过两次这种情况，一次是通过在另一个目录搞了一个链接过去，这个解决方案网上很多，一搜都是；另一次是因为服务器空间不足，删除一些应用之后mysql成功启动。但是这次在本机中这两种方法都没能解决问题，打开错误日志/var/log/mysql/error.log看到如下内容：

140417  7:30:38 [Note] Server hostname (bind-address): '10.213.214.138'; port: 3306
140417  7:30:38 [Note]   - '10.213.214.138' resolves to '10.213.214.138';
140417  7:30:38 [Note] Server socket created on IP: '10.213.214.138'.
140417  7:30:38 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
140417  7:30:38 [ERROR] Do you already have another mysqld server running on port: 3306 ?g
140417  7:30:38 [ERROR] Aborting

140417  7:30:38  InnoDB: Starting shutdown...
140417  7:30:39  InnoDB: Shutdown completed; log sequence number 5026365941

想起来之前修改过mysql的配置文件，添加过bind-address为了让远程机访问，现在日志显示连接不上该远程机ip了

[mysqld]
user    = mysql
pid-file  = /var/run/mysqld/mysqld.pid
socket    = /var/run/mysqld/mysqld.sock
port      = 3306
basedir   = /usr
datadir   = /var/lib/mysql
tmpdir    = /tmp
max_connections = 151
skip-external-locking

bind-address        = 127.0.0.1
bind-address        = 10.213.214.138

将bind-address = 10.213.214.138注释或者删掉就可以了。。。
重新启动mysql服务，一切正常。。。所以说看日志文件很重要