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

redhat

[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

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

redhat

[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

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

redhat

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

进不去什么错误信息？

redhat

[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

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

redhat

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

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

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