当前位置:Gxlcms > 数据库问题 > Can't connect to local MySQL server through socket

Can't connect to local MySQL server through socket

时间:2021-07-01 10:21:17 帮助过:27人阅读

(HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock

然后使用命令查看mysql是不是真的已经起来了

  1. <span style="color: #0000ff;">ps</span> -A|<span style="color: #0000ff;">grep</span> mysql

查看,两个进程都启动了,看着是正常,但是查看端口时发现3306端口并没有开启,什么问题???

接着查,看一下mysql当前处于什么状态

  1. service mysqld status

输出结果不是刚才想的那样:

MySQL is running but PID file could not be found

有网友提示将mysql进程杀死,然后重启,试了,无效。

查看mysql的错误日志,显示如下信息:

  1. /usr/local/mysql/bin/mysqld: Disk is full writing <span style="color: #800000;">‘</span><span style="color: #800000;">./mysql-bin.~rec~</span><span style="color: #800000;">‘</span> (Errcode: <span style="color: #800080;">28</span>). Waiting <span style="color: #0000ff;">for</span> someone to <span style="color: #0000ff;">free</span> space... (Expect up to <span style="color: #800080;">60</span> secs delay <span style="color: #0000ff;">for</span> server to continue after freeing disk space)

原来是磁盘不足,清理了下磁盘正常了。

Can't connect to local MySQL server through socket

标签:

人气教程排行