MySQL Plugin 'InnoDB' init function returned error.

最新推荐文章于 2024-03-10 10:58:50 发布
原创 最新推荐文章于 2024-03-10 10:58:50 发布 · 700 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#数据库 #运维

本文记录了XAMPP环境下MySQL无法启动的问题及其解决办法。通过删除MySQL安装目录下data文件夹中的所有文件，成功解决了启动时出现的Plugin'InnoDB'initfunctionreturnederror错误。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

下了xampp，启动MySQL
总是无法启动，查看事件日志后，发现有如下内容：
Plugin 'InnoDB' init function returned error.


查找答案时，有这样的说法：
[quote]只要删除MySQL目录下的ib_logfile0和ib_logfile1两个文件，就可以解决问题了。[/quote]
[url]http://www.pc9g.com/pw/read-htm-tid-77177.html[/url]
启动时，依然报错。

在网上搜索后，删除mysql目录下的data中所有文件后，重新启动后正常。


但是也有其他的解决情况，先暂且记录下来，以后备查吧...
[url]http://blog.nbedu.net.cn/user1/zsxx/archives/2009/10078.html[/url]
mysql 报Plugin ‘InnoDB‘ init function returned error. 解决方案
ふりこ细工の心
02-03 6135
异常信息 210203 09:40:34 mysqld_safe mysqld from pid file /data/mysql/mysql.pid ended 210203 09:41:20 mysqld_safe Starting mysqld daemon with databases from /data/mysql 210203 9:41:20 InnoDB: The InnoDB memory heap is disabled 210203 9:41:20 InnoDB: Mutexes
MySQL Plugin 'InnoDB' init function returned error一例
weixin_34383618的博客
08-12 2818
早上上班后，测试说演示环境挂了，维护上去看了下，启动报错了： XXXXXX08:30:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysqlXXXXXX08:30:50 [Warning] The syntax '--log-slow-queries' is deprecated and will be r...
mysql报错之Plugin ‘InnoDB‘ init function returned error
m0_62155641的博客
03-10 261
5
MySQL Plugin 'InnoDB' init function returned error
热门推荐
狐狸叫
02-12 4万+
MySQL Plugin 'InnoDB' init function returned error. . . 在MySQL的配置文件中，设定default-table-type=InnoDB，发现MySQL无法正常的启动，错误日志中给出了如下的信息：  引用 00703 09:28:53 mysqld_safe Starting mysqld daemon with databases
Plugin 'InnoDB' init function returned error.mysql的这个问题是什么
05-13
这个问题通常是由于 MySQL 数据库的 InnoDB 存储引擎损坏或无法正常启动所致。这可能是由于以下原因之一导致的： 1. 数据库文件已损坏。 2. InnoDB 存储引擎的配置文件设置不正确。 3. MySQL 服务无法访问 InnoDB ...
nnoDB: Operating system error number 13 in a file operation. 2023-05-29T14:49:07.065804Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2023-05-29T14:49:07.065818Z 0 [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions 2023-05-29T14:49:07.065834Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-29T14:49:07.666710Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-29T14:49:07.666781Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-29T14:49:07.666843Z 0 [ERROR] Failed to initialize builtin plugins. 2023-05-29T14:49:07.666860Z 0 [ERROR] Aborting解决办法
05-30
这个错误信息提示是因为 MySQL 没有权限访问目录，需要修改文件夹的权限或者修改 MySQL 的配置文件来解决。具体操作步骤如下： 1. 修改文件夹的权限：使用 chmod 命令修改目录的权限，如 chmod 777 /path/to/...
iot-database | 2025-07-04T08:52:27.546578Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). iot-database | 2025-07-04T08:52:27.556800Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created! iot-database | 2025-07-04T08:52:27.556866Z 0 [ERROR] InnoDB: redo log file './ib_logfile0' exists. Creating system tablespace with existing redo log files is not recommended. Please delete all redo log files before creating new system tablespace. iot-database | 2025-07-04T08:52:27.556875Z 0 [ERROR] InnoDB: InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again. iot-database | 2025-07-04T08:52:28.160527Z 0 [ERROR] Plugin 'InnoDB' init function returned error. iot-database | 2025-07-04T08:52:28.160579Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. iot-database | 2025-07-04T08:52:28.160587Z 0 [ERROR] Failed to initialize builtin plugins. iot-database | 2025-07-04T08:52:28.160590Z 0 [ERROR] Aborting
最新发布
07-05
ERROR] InnoDB: redo log file './ib_logfile0' exists. Creating system tablespace with existing redo log files is not recommended. ``` 这表明MySQL尝试初始化新的系统表空间时，发现残留的redo日志文件(ib_...
2012-08-04T13:34:48.100295Z 0 [System] [MY-013169] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) initializing of server in progress as process 6020 2012-08-04T13:34:48.236300Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2012-08-04T13:35:07.144382Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2012-08-04T13:35:39.446231Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2012-08-04T13:36:01.826510Z 0 [System] [MY-013169] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) initializing of server in progress as process 4016 2012-08-04T13:36:01.829510Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2012-08-04T13:36:01.830510Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\MySQL Server 8.0\Data\ is unusable. You can remove all files that the server added to it. 2012-08-04T13:36:01.833510Z 0 [ERROR] [MY-010119] [Server] Aborting 2012-08-04T13:36:01.833512Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2012-08-04T13:50:50.554656Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 4652 2012-08-04T13:50:50.619657Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2012-08-04T13:50:50.814669Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2012-08-04T13:50:50.815669Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2012-08-04T13:50:50.829669Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2012-08-04T13:50:50.830669Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2012-08-04T13:50:50.830670Z 0 [ERROR] [MY-010119] [Server] Aborting 2012-08-04T13:50:50.831674Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2012-08-04T13:51:39.728468Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 2836 2012-08-04T13:51:39.749467Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2012-08-04T13:51:39.933478Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2012-08-04T13:51:39.934478Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2012-08-04T13:51:39.938478Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2012-08-04T13:51:39.939478Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2012-08-04T13:51:39.939479Z 0 [ERROR] [MY-010119] [Server] Aborting 2012-08-04T13:51:39.940482Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:26:32.458715Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-06-26T11:26:32.474315Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2025-06-26T11:26:32.474315Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2025-06-26T11:26:32.474315Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2025-06-26T11:26:32.786315Z 0 [Note] mysqld (mysqld 5.7.31) starting as process 6620 ... 2025-06-26T11:26:33.098315Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2025-06-26T11:26:33.098315Z 0 [Note] InnoDB: Uses event mutexes 2025-06-26T11:26:33.098315Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2025-06-26T11:26:33.098315Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-06-26T11:26:33.113915Z 0 [Note] InnoDB: Number of pools: 1 2025-06-26T11:26:33.129515Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2025-06-26T11:26:33.191915Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2025-06-26T11:26:33.191915Z 0 [Note] InnoDB: Completed initialization of buffer pool 2025-06-26T11:26:33.332315Z 0 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:26:33.332315Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2025-06-26T11:26:33.550715Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2025-06-26T11:26:33.550715Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2025-06-26T11:26:33.550715Z 0 [ERROR] Failed to initialize builtin plugins. 2025-06-26T11:26:33.550715Z 0 [ERROR] Aborting 2025-06-26T11:26:33.550715Z 0 [Note] Binlog end 2025-06-26T11:26:33.566315Z 0 [Note] Shutting down plugin 'CSV' 2025-06-26T11:26:33.566315Z 0 [Note] mysqld: Shutdown complete 2025-06-26T11:29:24.760715Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-06-26T11:29:24.760715Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2025-06-26T11:29:24.760715Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2025-06-26T11:29:24.760715Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2025-06-26T11:29:24.760715Z 0 [Note] MySQL57 (mysqld 5.7.31) starting as process 6856 ... 2025-06-26T11:29:24.776315Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2025-06-26T11:29:24.776315Z 0 [Note] InnoDB: Uses event mutexes 2025-06-26T11:29:24.776315Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2025-06-26T11:29:24.776315Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-06-26T11:29:24.776315Z 0 [Note] InnoDB: Number of pools: 1 2025-06-26T11:29:24.776315Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2025-06-26T11:29:24.791915Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2025-06-26T11:29:24.807515Z 0 [Note] InnoDB: Completed initialization of buffer pool 2025-06-26T11:29:25.072715Z 0 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:29:25.072715Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2025-06-26T11:29:25.400315Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2025-06-26T11:29:25.400315Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2025-06-26T11:29:25.400315Z 0 [ERROR] Failed to initialize builtin plugins. 2025-06-26T11:29:25.400315Z 0 [ERROR] Aborting 2025-06-26T11:29:25.400315Z 0 [Note] Binlog end 2025-06-26T11:29:25.400315Z 0 [Note] Shutting down plugin 'CSV' 2025-06-26T11:29:25.400315Z 0 [Note] MySQL57: Shutdown complete 2025-06-26T11:30:11.679515Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-06-26T11:30:11.679515Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2025-06-26T11:30:11.679515Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2025-06-26T11:30:11.679515Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2025-06-26T11:30:11.680515Z 0 [Note] MySQL57 (mysqld 5.7.31) starting as process 1328 ... 2025-06-26T11:30:11.696515Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2025-06-26T11:30:11.697515Z 0 [Note] InnoDB: Uses event mutexes 2025-06-26T11:30:11.698515Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2025-06-26T11:30:11.698515Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-06-26T11:30:11.699515Z 0 [Note] InnoDB: Number of pools: 1 2025-06-26T11:30:11.700515Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2025-06-26T11:30:11.707515Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2025-06-26T11:30:11.727515Z 0 [Note] InnoDB: Completed initialization of buffer pool 2025-06-26T11:30:11.785515Z 0 [ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:30:11.786515Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2025-06-26T11:30:11.987515Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2025-06-26T11:30:11.987515Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2025-06-26T11:30:11.988515Z 0 [ERROR] Failed to initialize builtin plugins. 2025-06-26T11:30:11.988515Z 0 [ERROR] Aborting 2025-06-26T11:30:11.989515Z 0 [Note] Binlog end 2025-06-26T11:30:11.989515Z 0 [Note] Shutting down plugin 'CSV' 2025-06-26T11:30:11.990515Z 0 [Note] MySQL57: Shutdown complete 2025-06-26T11:32:29.799516Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) starting as process 6768 2025-06-26T11:32:29.932515Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T11:32:30.217515Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:32:30.218515Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T11:32:30.222515Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T11:32:30.223515Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T11:32:30.223516Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:32:30.225515Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:33:11.431517Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 5844 2025-06-26T11:33:11.453515Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T11:33:11.646515Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:33:11.647515Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T11:33:11.651515Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T11:33:11.652515Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T11:33:11.652516Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:33:11.653519Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:37:44.455517Z 0 [System] [MY-013169] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) initializing of server in progress as process 5416 2025-06-26T11:37:44.459515Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2025-06-26T11:37:44.460515Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\MySQL Server 8.0\data\ is unusable. You can remove all files that the server added to it. 2025-06-26T11:37:44.477515Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:37:44.477517Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:37:47.993517Z 0 [System] [MY-013169] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) initializing of server in progress as process 3268 2025-06-26T11:37:47.996515Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2025-06-26T11:37:47.997515Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\MySQL Server 8.0\data\ is unusable. You can remove all files that the server added to it. 2025-06-26T11:37:47.999515Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:37:48.000516Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:44:45.414317Z 0 [System] [MY-013169] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) initializing of server in progress as process 7160 2025-06-26T11:44:45.417315Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2025-06-26T11:44:45.418315Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\MySQL Server 8.0\data\ is unusable. You can remove all files that the server added to it. 2025-06-26T11:44:45.421315Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:44:45.421317Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:50:18.940316Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 2960 2025-06-26T11:50:19.707315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T11:50:20.882315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:50:20.889315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T11:50:20.933315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T11:50:20.943315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T11:50:20.943316Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:50:21.013315Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:54:54.948317Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) starting as process 5396 2025-06-26T11:54:55.006315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T11:54:55.988315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:54:56.000315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T11:54:56.044315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T11:54:56.054315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T11:54:56.055315Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:54:56.124315Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:54:59.535315Z 0 [ERROR] [MY-010083] [Server] --verbose is for use with --help; did you mean --log-error-verbosity? 2025-06-26T11:54:59.536316Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) starting as process 6260 2025-06-26T11:54:59.557315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T11:54:59.763315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:54:59.764315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T11:54:59.768315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T11:54:59.769315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T11:54:59.769316Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:54:59.770320Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:55:49.378317Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) starting as process 6884 2025-06-26T11:55:49.412315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T11:55:49.607315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:55:49.608315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T11:55:49.612315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T11:55:49.613315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T11:55:49.613316Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:55:49.614319Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T11:59:23.848317Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) starting as process 6500 2025-06-26T11:59:23.870315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T11:59:24.138315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T11:59:24.145315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T11:59:24.190315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T11:59:24.199315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T11:59:24.200315Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T11:59:24.270315Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T12:00:11.464315Z 0 [ERROR] [MY-010083] [Server] --verbose is for use with --help; did you mean --log-error-verbosity? 2025-06-26T12:00:11.464318Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) starting as process 5528 2025-06-26T12:00:11.506315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T12:00:11.712315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T12:00:11.713315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T12:00:11.717315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T12:00:11.718315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T12:00:11.718316Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T12:00:11.719319Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T12:00:48.273317Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.42) starting as process 6076 2025-06-26T12:00:48.312315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T12:00:48.525315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T12:00:48.526315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T12:00:48.530315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T12:00:48.531315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T12:00:48.531316Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T12:00:48.532320Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-26T12:02:01.665317Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 5008 2025-06-26T12:02:01.715315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-26T12:02:01.927315Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-26T12:02:01.928315Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-26T12:02:01.932315Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-26T12:02:01.933315Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-26T12:02:01.933316Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-26T12:02:01.934320Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-27T08:49:33.665262Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 1656 2025-06-27T08:49:38.251669Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-27T08:49:38.782070Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-27T08:49:38.813270Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-27T08:49:38.875670Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-27T08:49:38.891270Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-27T08:49:38.891271Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-27T08:49:38.922470Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-27T09:23:59.010941Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 5100 2025-06-27T09:24:00.153005Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-27T09:24:00.765040Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-27T09:24:00.776041Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-27T09:24:00.802042Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-27T09:24:00.810043Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-27T09:24:00.811043Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-27T09:24:00.851045Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-27T10:45:57.915815Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 3404 2025-06-27T10:45:58.574852Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-27T10:45:59.277892Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-27T10:45:59.289893Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-27T10:45:59.315895Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-27T10:45:59.323895Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-27T10:45:59.323896Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-27T10:45:59.363897Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-06-27T10:47:26.056858Z 0 [System] [MY-010116] [Server] D:\MySQL Server 8.0\bin\mysqld (mysqld 8.0.42) starting as process 4556 2025-06-27T10:47:26.083857Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-06-27T10:47:26.411876Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2025-06-27T10:47:26.412876Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2025-06-27T10:47:26.416876Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2025-06-27T10:47:26.417877Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-06-27T10:47:26.417878Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-06-27T10:47:26.418882Z 0 [System] [MY-010910] [Server] D:\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL.
06-28
[ERROR] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. ``` 这表明您的MySQL数据目录存在严重损坏，需要彻底...
解决 MySQL 错误1067：进程意外终止 Plugin 'InnoDB' init function returned error.
u011279474的博客
02-10 4071
错误： 错误 1067：进程意外终止 ### 第一步： 打开事件查看器 > 应用程序 > 查看错误 我这里发生了 4 个错误，分别为： Plugin 'InnoDB' init function returned error. Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Unknown/unsupported st...
Plugin 'InnoDB' init function returned error
fred's blog
12-01 1万+
 mysql启动错误日志出现以下错误<br /># tail -f /opt/mysql/var/localhost.localdomain.errInnoDB: a big enough maximum process size. InnoDB: Note that in most 32-bit computers the processInnoDB: memory space is limited to 2 GB or 4 GB.InnoDB: We keep retrying the alloca
关于Mysql数据库报 Plugin ‘InnoDB‘ init function returned error.有重要数据的处理方法！！
hfthxfhjy的博客
06-15 882
完成后将innodb_force_recovery=0，innodb_purge_threads=1，（也可以去掉这两个配置）(SRV_FORCE_NO_UNDO_LOG_SCAN):不查看重做日志，InnoDB存储引擎会将未提交的事务视为已提交。(SRV_FORCE_NO_IBUF_MERGE):不执行插入缓冲的合并操作。(SRV_FORCE_NO_TRX_UNDO):不执行事务回滚操作。(SRV_FORCE_NO_LOG_REDO):不执行前滚的操作。执行逻辑导出，导出需要的数据库。
mysql Plugin 'InnoDB' init function returned error
swanabin的专栏
07-29 1万+
转自VC错误:http://www.vcerror.com/?p=1975 问题描述： 非正常关闭mysql，同时更改了my.cnf 导致启动时不支持innodb，出现如下错误： [ERROR] Plugin 'InnoDB' init function returned error. [ERROR] Plugin 'InnoDB' registration as a STORAGE EN
init function mysql_MySQL Plugin 'InnoDB' init function returned error
weixin_39928667的博客
02-06 258
. . 在MySQL的配置文件中，设定default-table-type=InnoDB，发现MySQL无法正常的启动，错误日志中给出了如下的信息：150210 18:11:19 mysqld_safe mysqld from pid file /data/mysqldata/mysql.pid ended150210 18:15:20 mysqld_safe Starting mysqld da...
MySql5.5 Plugin 'InnoDB' init function returned error
技术需要沉淀，需要碰撞。
05-27 7245
公司服务器MySql数据库挂掉，N个项目都在用，摊上大事了。错误： Plugin 'InnoDB' init function returned error.Plugin 'InnoDB' registration as a STORAGE ENGINE failed.Unknown/unsupported table type: INNODB 刻不容缓，马上百度，得出的结论都是很不负责任的，
解决[ERROR] Plugin ‘InnoDB‘ init function returned error
Kason_iWiki
03-12 2219
背景：db container无法正常启动 分析日志： 2021-03-12 2:14:32 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 239672591 between the checkpoint 239672591 and the end 239672320. 2021-03-12 2:14:32 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2021
init function mysql_Plugin 'InnoDB' init function returned error
weixin_34483980的博客
02-06 375
mysql启动错误日志出现以下错误# tail -f /opt/mysql/var/localhost.localdomain.errInnoDB: a big enough maximum process size.InnoDB: Note that in most 32-bit computers the processInnoDB: memory space is limited to 2 ...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值