mysql-5.1.42安装完成后,出现如下错误:
bash-3.00# ./mysqld_safe &
[1] 2307
bash-3.00# 100114 23:04:33 mysqld_safe Logging to '/opt/mysql/mysql/data/MYHZ.err'.
100114 23:04:33 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/mysql/data
100114 23:04:34 mysqld_safe mysqld from pid file /opt/mysql/mysql/data/MYHZ.pid ended
查看log有以下报错:
100114 22:51:40 InnoDB: Started; log sequence number 0 44233
100114 22:51:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100114 22:51:40 mysqld_safe mysqld from pid file /opt/mysql/mysql/data/MYHZ.pid ended
解决办法:
bash-3.00# cd /opt/mysql/mysql/data
bash-3.00# rmdir mysql
bash-3.00# rmdir test
bash-3.00# ln -s /var/lib/mysql/mysql /opt/mysql/mysql/data/mysql
bash-3.00# ln -s /var/lib/mysql/test /opt/mysql/mysql/data/test