linux 启动mysql 时报：Table 'mysql.host' doesn't exist

最新推荐文章于 2022-03-28 16:51:24 发布

原创最新推荐文章于 2022-03-28 16:51:24 发布 · 822 阅读

1 ·

CC 4.0 BY-SA版权

本文详细记录了在yum安装MySQL后遇到MySQLDaemon无法启动的问题，通过排查日志发现是安装路径与数据路径不匹配导致。文章指导读者如何重新运行mysql_install_db命令修正路径错误，并最终成功启动MySQL服务。

[root@www mysql]# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

今天在yum完mysql之后，报错：MySQL Daemon failed to start.

查看日志，原因如下：

140725 23:50:24 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' d
oesn't exist
140725 23:50:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140725 23:51:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140725 23:51:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

发现时是安装的路径与数据路径不对，重新运行：mysql_install_db --usrer=mysql --datadir=/var/lib/mysql

[root@www mysql]# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]

再次启动，正常。