mysql 变更数据目录以后 mysql服务不能启动

dc10221203

130122 23:16:28 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130122 23:16:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130122 23:16:28  InnoDB: Initializing buffer pool, size = 16.0M
130122 23:16:28  InnoDB: Completed initialization of buffer pool
130122 23:16:28  InnoDB: Started; log sequence number 0 44233
130122 23:16:28 [Note] Recovering after a crash using mysql-bin
130122 23:16:28 [Note] Starting crash recovery...
130122 23:16:28 [Note] Crash recovery finished.
130122 23:16:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130122 23:16:28 mysqld_safe mysqld from pid file /home/data/mysql//b2b114.pid ended
130122 23:18:42 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130122 23:18:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130122 23:18:42  InnoDB: Initializing buffer pool, size = 16.0M
130122 23:18:42  InnoDB: Completed initialization of buffer pool
130122 23:18:42  InnoDB: Started; log sequence number 0 44233
130122 23:18:42 [Note] Recovering after a crash using mysql-bin
130122 23:18:42 [Note] Starting crash recovery...
130122 23:18:42 [Note] Crash recovery finished.
130122 23:18:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130122 23:18:42 mysqld_safe mysqld from pid file /home/data/mysql//b2b114.pid ended
130122 23:23:08 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130122 23:23:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130122 23:23:08  InnoDB: Initializing buffer pool, size = 16.0M
130122 23:23:08  InnoDB: Completed initialization of buffer pool
130122 23:23:09  InnoDB: Started; log sequence number 0 44233
130122 23:23:09 [Note] Recovering after a crash using mysql-bin
130122 23:23:09 [Note] Starting crash recovery...
130122 23:23:09 [Note] Crash recovery finished.
130122 23:23:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130122 23:23:09 mysqld_safe mysqld from pid file /home/data/mysql//b2b114.pid ended




mysql 变更数据目录以后 mysql服务不能启动？？？？？？

licess

/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130122 23:16:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

copy数据库目录时可能mysql.plugin没cp过去，重新在cp一次试试

lovegx999

重新安装一下得；了