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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130122 23:16:28InnoDB: Initializing buffer pool, size = 16.0M
130122 23:16:28InnoDB: Completed initialization of buffer pool
130122 23:16:28InnoDB: Started; log sequence number 0 44233
130122 23:16:28 Recovering after a crash using mysql-bin
130122 23:16:28 Starting crash recovery...
130122 23:16:28 Crash recovery finished.
130122 23:16:28 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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130122 23:18:42InnoDB: Initializing buffer pool, size = 16.0M
130122 23:18:42InnoDB: Completed initialization of buffer pool
130122 23:18:42InnoDB: Started; log sequence number 0 44233
130122 23:18:42 Recovering after a crash using mysql-bin
130122 23:18:42 Starting crash recovery...
130122 23:18:42 Crash recovery finished.
130122 23:18:42 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 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130122 23:23:08InnoDB: Initializing buffer pool, size = 16.0M
130122 23:23:08InnoDB: Completed initialization of buffer pool
130122 23:23:09InnoDB: Started; log sequence number 0 44233
130122 23:23:09 Recovering after a crash using mysql-bin
130122 23:23:09 Starting crash recovery...
130122 23:23:09 Crash recovery finished.
130122 23:23:09 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服务不能启动？？？？？？ /usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130122 23:16:28 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
copy数据库目录时可能mysql.plugin没cp过去，重新在cp一次试试 重新安装一下得；了:) :) :) :)
页:
[1]