mysql突然连接不上了 之前都好好的

imgsworld

mysql突然连接不上了 之前都好好的

打开装了discuz x3的论坛提示：
Discuz! Database Error
(2002) notconnect

在putty里面输入“# mysql”提示如下：
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

关闭mysql时一直提示：shutting down mysql ……………………………………………………………………一直关不掉……

通过这个网址（http://www.szxhyw.com/other/phpmyadmin/）可以访问phpmyadmin ，但是输入正确的用户名和密码也无法登录，连提示都没有!
1、VPS系统：centos 64位

2、“mysql err文件” 和 “lnmp_install log文件” 见如下附件






[ 本帖最后由 imgsworld 于 2013-9-4 17:15 编辑 ]

licess

按置顶帖要求提供mysql日志看看

imgsworld

1、VPS系统：centos 64位

2、“mysql err文件” 和 “lnmp_install log文件” 见如下附件





[ 本帖最后由 imgsworld 于 2013-9-4 17:19 编辑 ]

licess

130902  9:45:20 [ERROR] /usr/local/mysql/bin/mysqld: Disk is full writing './discuz/discuz_forum_post.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
130902  9:45:20 [ERROR] /usr/local/mysql/bin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
130902  9:45:44 [ERROR] /usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000047' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
130902  9:45:44 [ERROR] /usr/local/mysql/bin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
130902  9:46:44 [ERROR] /usr/local/mysql/bin/mysqld: Disk is full writing './mysql-bin.000047' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
130902  9:46:44 [ER130902 17:21:06 mysqld_safe A mysqld process already exists
130902 17:33:49 mysqld_safe A mysqld process already exists
按上面的错误磁盘空间或分区满了

imgsworld

具体怎么解决啊，磁盘没满啊  可不可以我把root 密码给您，您帮我看看

licess

按日志看目前是这个情况

清空一下mysql 日志后看看

imgsworld

无法执行清除日志命令   输入密码时提示如下：
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
手动删除了一些日志文件，发现无效
而且mysql一直无法关闭，关闭的时候会停在这里“Shutting down MySQL..................................................................“

我给您root密码，您帮我试试吧(密码短消息给您了)

[ 本帖最后由 imgsworld 于 2013-9-7 17:03 编辑 ]

licess

直接kill掉 或重启后看看
登陆不上

imgsworld

kill mysql我不会啊  但是重启过服务器，现在还是得不到解决，您帮我看看吧  求您了  

密码还是那个密码，之前我发错了，现在我把密码改成我发的那个了，现在应该可以登录了

licess

ps aux找mysql的pid，然后kill pid的数字

直接就是连接不上