mysql问题，请高手解决？？？

szjq

用rpm方式安装了mysq 3.23
然后用/etc/rc.d/init.d/msyql start
显示：
Starting mysqld daemon with databases from /var/lib/mysql
031014 15:51:09  mysqld ended
然后就不动了，用
/usr/bin/mysql 启动时，显示：
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

这是什么原因，查看进程时，显示mysql已经启动，有什么办法解决吗？
用phpmyadmin也访问不到，说是:

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/mysql/libraries/auth/config.auth.lib.php:91) in /var/www/html/mysql/header.inc.php on line 23

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/mysql/libraries/auth/config.auth.lib.php:91) in /var/www/html/mysql/header.inc.php on line 24

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/mysql/libraries/auth/config.auth.lib.php:91) in /var/www/html/mysql/header.inc.php on line 25

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/mysql/libraries/auth/config.auth.lib.php:91) in /var/www/html/mysql/header.inc.php on line 26

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/mysql/libraries/auth/config.auth.lib.php:91) in /var/www/html/mysql/header.inc.php on line 27

Warning: Cannot add header information - headers already sent by (output started at /var/www/html/mysql/libraries/auth/config.auth.lib.php:91) in /var/www/html/mysql/header.inc.php on line 29

Error

MySQL said:


Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

高手快帮忙，在线等

xiaqii

rpm方式不知道。

不过一般来说源码方式是： 配置、make、make install. 初始化，设置权限。


初始化，设置权限。 这2步如果做的不好容易出现那种一运行mysql就end的情况。

jawe

检查你的 /var/lib/mysql 权限。 应该是

drwxr-xr-x    4 mysql    mysql        4096 Oct 13 22:24 mysql

chown -R mysql /var/lib/mysql/mysql
chgrp -R daemons /var/lib/mysql/mysql

苍鹰

我也有这样的问题--不过我是从源代码安装的
就是初始华,设置权限有点乱
能给出正确的具体的命令吗?
多谢