VPS侦探论坛

标题: Mysql安装后起不来【附日志】 [打印本页]

作者: redhat 时间: 2012-6-28 00:08
标题: Mysql安装后起不来【附日志】
[root@centos var]# more centos.err
120627 23:30:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120627 23:30:17 [ERROR] Can't start server : Bind on unix socket: Permission denied
120627 23:30:17 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
120627 23:30:17 [ERROR] Aborting

120627 23:30:17 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120627 23:30:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos.pid ended
120627 23:30:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120627 23:30:18 [ERROR] Can't start server : Bind on unix socket: Permission denied
120627 23:30:18 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
120627 23:30:18 [ERROR] Aborting

120627 23:30:18 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120627 23:30:18 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos.pid ended
120627 23:39:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120627 23:39:22 [ERROR] Can't start server : Bind on unix socket: Permission denied
120627 23:39:22 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
120627 23:39:22 [ERROR] Aborting

120627 23:39:22 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120627 23:39:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos.pid ended
120627 23:46:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120627 23:46:34 [ERROR] Can't start server : Bind on unix socket: Permission denied
120627 23:46:34 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
120627 23:46:34 [ERROR] Aborting

120627 23:46:34 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120627 23:46:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos.pid ended

提示已经有起一个mysql，但是我ps看过，确实没有，不知道为何会这样！

作者: licess 时间: 2012-6-28 10:51
可能已经有mysql在运行，netstat -ntl看看端口和/tmp 目录下是否有 mysql.sock

作者: redhat 时间: 2012-6-28 11:27
[root@centos Public]# netstat -ntl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address             Foreign Address          State
tcp       0    0 0.0.0.0:80                0.0.0.0:*                LISTEN
tcp       0    0 0.0.0.0:22                0.0.0.0:*                LISTEN
tcp       0    0 0.0.0.0:17500             0.0.0.0:*                LISTEN
tcp       0    0 :::22

没有3306端口，而且tmp 目录下没有 mysql.sock文件

作者: licess 时间: 2012-6-28 11:29
哪可能是/tmp 目录的权限问题

作者: redhat 时间: 2012-6-28 15:40
我把/tmp给chmod 777后，再起mysql，发现可以起来了

但是mysql -uroot -p老进不去，
按照这个方法：
======================================================================================
如果忘记MySQL root密码，如何重设密
码？
执行如下命令：wget http://soft.vpser.net/lnmp/ext/reset-mysql-root-password.phps;php reset-mysql-root-password.phps 新密码
======================================================================================
试过，仍然不行，通过phpmyadmin也登陆不进去。

作者: licess 时间: 2012-6-28 17:19
标题: 回复 5# 的帖子
进不去什么错误信息？

作者: redhat 时间: 2012-6-28 20:55
[root@centos ~]# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user [email=]'root'@'localhost'[/email] (using password: YES)

如果用phpmyadmin登陆，就会提示：
#1045 无法登录 MySQL 服务器

作者: licess 时间: 2012-6-28 21:23
标题: 回复 7# 的帖子
https://bbs.vpser.net/thread-6194-1-1.html

作者: redhat 时间: 2012-6-29 22:38
ssh上指令都进不去，这个跟phpmyadmin配置应该没关系
[root@centos ~]# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

按老大提供的方法修改后，ssh和网页还是进不去

快要崩溃了，几天了，还是搞不定啊

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)