cant find file mysql host.frm_MYSQL启动失败，提示Can't find file: './mysql/host.frm'解决办法...

110315 10:17:51  InnoDB: Started; log sequence number 0 43655

110315 10:17:51 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

110315 10:17:51 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

110315 10:17:51 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

110315 10:17:51  mysqld ended

解决办法：

这主要是没有权限读取，给个权限就OK了

1： 初始化数据库做了没有？

/usr/local/mysql/bin/mysqld_install_db --user=mysql

2：权限问题

chown -R root.mysql /usr/local/mysql/

chown -R mysql /usr/local.mysql/var/

调整lib库路径：

echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf

重新加载配置

ldconfig

启动mysql

/usr/local/mysql/bin/mysql_safe --user=mysql &

查看是否启动了

netstat -ntpl | grep 3306

欢迎转载 请注明 流浪的风 qq 544040277