redhat 发表于 2012-6-28 00:08:28

Mysql安装后起不来【附日志】

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

120627 23:30:17 /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 Can't start server : Bind on unix socket: Permission denied
120627 23:30:18 Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
120627 23:30:18 Aborting

120627 23:30:18 /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 Can't start server : Bind on unix socket: Permission denied
120627 23:39:22 Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
120627 23:39:22 Aborting

120627 23:39:22 /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 Can't start server : Bind on unix socket: Permission denied
120627 23:46:34 Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
120627 23:46:34 Aborting

120627 23:46:34 /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:05

可能已经有mysql在运行，netstat -ntl看看端口 和/tmp 目录下是否有 mysql.sock

redhat 发表于 2012-6-28 11:27:06

# 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:45

哪可能是/tmp 目录的权限问题

redhat 发表于 2012-6-28 15:40:08

我把/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:17

回复 5# 的帖子

进不去什么错误信息？

redhat 发表于 2012-6-28 20:55:12

# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

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

licess 发表于 2012-6-28 21:23:10

回复 7# 的帖子

https://bbs.vpser.net/thread-6194-1-1.html

redhat 发表于 2012-6-29 22:38:04

ssh上指令都进不去，这个跟phpmyadmin配置应该没关系
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

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

快要崩溃了，几天了，还是搞不定啊
页: [1]
查看完整版本: Mysql安装后起不来【附日志】