VPS侦探论坛

标题: mysql 变更数据目录以后 mysql服务不能启动 [打印本页]

作者: dc10221203    时间: 2013-1-23 07:59
标题: mysql 变更数据目录以后 mysql服务不能启动
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    时间: 2013-1-23 08:33
/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    时间: 2013-1-24 09:37
重新安装一下得;了




欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/) Powered by Discuz! X3.4