执行mysql的mysql_install_db报错，mysql启动失败

davie5201314

root@dnion bin]# ./mysql_install_db -u mysql
WARNING: The host 'dnion' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
091018 14:58:57 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/db.frm' (errno: 13)
091018 14:58:57 [ERROR] Aborting

091018 14:58:57 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

chenyx

This means that you should use IP addresses instead of hostnames

检查下你的host文件是否正确设置了ip->host对应

davie5201314

host文件在什么位置，这是在linux下安装的

chenyx

/etc/hosts

vermouth

/usr/local/mysql/libexec/mysqld: Can't find file: './mysql/db.frm'
你运行脚本的位置不对吧？ mysql 安装的时候会告诉你 cd 到哪，再执行什么命令啊。

davie5201314

恩，谢谢，第一段的错误提示是没了，下面的还是存在

davie5201314

我安装的时候直接./configure --prefix=/usr/local/下了
然后，我make install后，在usr/local/mysql/bin下执行的./mysql_install_db --user=mysql命令
请问这样有错吗？

chenyx

用绝对路径调用下mysql_install_db --user=mysql命令

aaaaa5aa

如果你是用mysql用户来启动MYSQL的话)

cd /usr/local/mysql
bin/mysql_install_db --user=mysql

davie5201314

回复 9# aaaaa5aa


    我直接用的root用户