FC5第一次运行系统自带的MySQL总是提示这个信息

skykingf

Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060814 20:55:51  mysqld ended

用google查了很多资料都俄有解决
请高手指教


用root登录也不行

[root@AquaSpace Movie]# mysqld_safe --user=root
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060814 21:24:19  mysqld ended



加上&也试过了
还是不行

版主我到哪里查看能找到原因呢？

我的FC5是刚装上的，还没有运行过MySQL呢

MySQL是系统自带的

skykingf

我看了看/var/log/mysqld.log



这句好像是问题的原因

060814 20:25:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
060814 20:25:07  mysqld ended


不过怎么解决我还不知道

skykingf

运行了一下mysql_install_db

还是不行
不过这次的log信息变了

060815 13:44:49 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060815 13:44:49 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060815 13:44:49 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

skykingf

运行了一下mysql_install_db

还是不行
不过这次的log信息变了

060815 13:44:49 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060815 13:44:49 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060815 13:44:49 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

skykingf

后来把／var/lib/mysql/mysql/的属主 改成mysql就启动起来了

高兴ing