编译的mysql5.1启动不了，求救高手，谢谢(已解决)

HH106

系统是centos5.2
官网上下载的mysql-5.1.34.tar.gz源码编译安装
编译时只加了如下参数，安装正常，没有任何错误
root@centos-lamp mysql-5.1.34]#./configure --prefix=/usr/local/mysql --sysconfdir=/etc
root@centos-lamp mysql-5.1.34]#make ; make install
[root@centos-lamp mysql-5.1.34]#groupadd mysql
[root@centos-lamp mysql-5.1.34]#useradd -g mysql mysql
[root@centos-lamp mysql-5.1.34]#cp support-files/my-large.cnf /etc/my.cnf
[root@centos-lamp mysql-5.1.34]#cd /usr/local/mysql
[root@centos-lamp mysql]#chown -R mysql .
[root@centos-lamp mysql]#chgrp -R mysql .
[root@centos-lamp mysql]#bin/mysql_install_db --user=mysql
[root@centos-lamp mysql]#bin/mysqld_safe --user=mysql &
[1] 20501
[root@centos-lamp mysql]# 090509 11:19:31 mysqld_safe Logging to '/usr/local/mysql/var/centos-lamp.err'.
090509 11:19:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090509 11:19:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos-lamp.pid ended
[1]+  Done                    bin/mysqld_safe --user=mysql
[root@centos-lamp mysql]#

centos-lamp.err错误信息也说得不清楚
[root@centos-lamp mysql]# tail /usr/local/mysql/var/centos-lamp.err
090509 10:58:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090509 10:58:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos-lamp.pid ended
090509 11:03:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090509 11:03:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos-lamp.pid ended
090509 11:05:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090509 11:05:29 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos-lamp.pid ended
090509 11:19:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090509 11:19:29 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos-lamp.pid ended
090509 11:19:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090509 11:19:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos-lamp.pid ended
[root@centos-lamp mysql]#

用root用户启动也一样
[root@centos-lamp mysql]# bin/mysqld_safe --user=root &
[1] 20617
[root@centos-lamp mysql]# 090509 11:20:48 mysqld_safe Logging to '/usr/local/mysql/var/centos-lamp.err'.
090509 11:20:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090509 11:20:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/centos-lamp.pid ended
[1]+  Done                    bin/mysqld_safe --user=root

文件夹权限如下
[root@centos-lamp mysql]# pwd
/usr/local/mysql
[root@centos-lamp mysql]# ll
总计 36
drwxr-xr-x  2 mysql mysql 4096 05-09 10:23 bin
drwxr-xr-x  2 mysql mysql 4096 05-09 10:17 docs
drwxr-xr-x  3 mysql mysql 4096 05-09 10:17 include
drwxr-xr-x  3 mysql mysql 4096 05-09 10:17 lib
drwxr-xr-x  2 mysql mysql 4096 05-09 10:18 libexec
drwxr-xr-x 10 mysql mysql 4096 05-09 10:18 mysql-test
drwxr-xr-x  5 mysql mysql 4096 05-09 10:18 share
drwxr-xr-x  5 mysql mysql 4096 05-09 10:18 sql-bench
drwx------  4 mysql mysql 4096 05-09 11:08 var

[root@centos-lamp mysql]# ll var
总计 736
-rwx------ 1 mysql mysql   1104 05-09 11:20 centos-lamp.err
drwx------ 2 mysql mysql    4096 05-09 11:08 mysql
-rw-r--r-- 1 mysql mysql  18943 05-09 10:31 mysql-bin.000001
-rw-r--r-- 1 mysql mysql 709496 05-09 10:31 mysql-bin.000002
-rw-r--r-- 1 mysql mysql     38 05-09 10:31 mysql-bin.index
-rw-r--r-- 1 mysql mysql      0 05-09 10:36 show
drwx------ 2 mysql mysql   4096 05-09 10:20 test

解决方法
严格按照压缩包里的INSTALL-SOURCE重新编译安装了一次就成功了
应该是权限问题，最后目录权限如下
[root@centos-lamp mysql]# ll
总计 36
drwxr-xr-x  2 root  mysql 4096 05-09 10:19 bin
drwxr-xr-x  2 root  mysql 4096 05-09 10:19 docs
drwxr-xr-x  3 root  mysql 4096 05-09 10:19 include
drwxr-xr-x  3 root  mysql 4096 05-09 10:19 lib
drwxr-xr-x  2 root  mysql 4096 05-09 10:20 libexec
drwxr-xr-x 10 root  mysql 4096 05-09 10:20 mysql-test
drwxr-xr-x  5 root  mysql 4096 05-09 10:20 share
drwxr-xr-x  5 root  mysql 4096 05-09 10:20 sql-bench
drwx------  4 mysql root  4096 05-09 10:28 var

[ 本帖最后由 HH106 于 2009-5-11 09:20 编辑 ]

songpure520

是不是系统里已经有MYSQL存在？

HH106

原帖由 songpure520 于 2009-5-9 17:20 发表
是不是系统里已经有MYSQL存在？

谢谢，没有mysql，新装的系统，只有基本系统

HH106

顶起，请教高手