Table 'mysql.host' doesn't exist
Posted
by
eriktm
on Server Fault
See other posts from Server Fault
or by eriktm
Published on 2010-09-13T08:29:35Z
Indexed on
2010/12/27
3:55 UTC
Read the original article
Hit count: 226
100913 10:21:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
100913 10:21:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100913 10:21:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100913 10:21:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
This is the output from the log-file for mysqld I get when I try to start mysqld with the mysqld_safe
command. I tried to run mysql_upgrade
to correct the first error, but this command seems to require the server to be started, which is my original problem.
Next, it says that the table mysql.host
does not exist. I was unable to figure out what this is caused by.
© Server Fault or respective owner