Mysql 1067错误

最新推荐文章于 2025-04-11 14:26:02 发布

新人小菜鸟

最新推荐文章于 2025-04-11 14:26:02 发布

阅读量610

点赞数

分类专栏： MySql 文章标签： mysql initialization server buffer table database

本文链接：https://blog.youkuaiyun.com/zju_ly/article/details/6760896

版权

MySql 专栏收录该内容

6 篇文章

订阅专栏

今天启动MySql，出现1067错误

A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.

在C:\ProgramData\MySQL\MySQL Server 5.1\data\LY-PC.err错误日志上看到如下错误

110908 16:19:51 [Note] Plugin 'FEDERATED' is disabled.
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table 'mysql.plugin' doesn't exist
110908 16:19:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110908 16:19:52  InnoDB: Initializing buffer pool, size = 42.0M
110908 16:19:52  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110908 16:19:52  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110908 16:19:52  InnoDB: Started; log sequence number 0 600599702
110908 16:19:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

后来发现C:\ProgramData\MySQL\MySQL Server 5.1\data\目录下没有mysql文件，从其他机子上拷贝过来后，顺利启动mysql