mysql启动错误，请教各位了！~

kai5454

[root@localhost mysqld]# /usr/local/mysql/bin/mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
080522 19:59:32  mysqld ended

[root@localhost mysqld]# /usr/local/mysql/bin/mysqld_safe &
[1] 3444


这是我安装完mysql后的启动错误，后来我查到了是无法创建pid文件，于是我
touch /var/run/mysqld/mysqld.pid
chown -R mysql:mysql /var/run/mysqld/

不过当我在 /usr/local/mysql/bin/mysqld_safe &
还是报如上错误，在到/var/run/mysqld/里看，刚刚创建的mysqld.pid已经消失了，我很奇怪，希望大家帮我解答一下，谢谢了！


[root@localhost run]# cd mysqld
[root@localhost mysqld]# ls
[root@localhost mysqld]#
[root@localhost mysqld]#
[root@localhost mysqld]# touch /var/run/mysqld/mysqld.pid
[root@localhost mysqld]# ls
mysqld.pid
[root@localhost mysqld]# cd ..
[root@localhost run]# chown -R mysql:mysql mysqld
[root@localhost run]# /usr/local/mysql/bin/mysqld_safe &
[1] 3523
[root@localhost run]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
080522 20:10:42  mysqld ended


[1]+  Done                    /usr/local/mysql/bin/mysqld_safe
[root@localhost run]#
[root@localhost run]#

wtuter

pid文件不是手动建的,错误不明,应该是你的mysq目录的权限问题,把mysql的目录ll上来

kai5454

谢谢哥们，问题已经解决了，在创建mysql授权表的时候
/usr/local/mysql/bin/mysql_install_db --user=mysql
就OK了，多谢