MYSQL报错 [ERROR] InnoDB: Unable to create temporary file； errno: 0

本文主要是介绍MYSQL报错 [ERROR] InnoDB: Unable to create temporary file； errno: 0，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

起因

服务器的mysql不支持远程访问，在修改完相关配置后重启服务出错。

2023-12-03T10:12:23.895459Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.22-log) starting as process 15684 ...
2023-12-03T10:12:23.908886Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-12-03T10:12:23.909640Z 0 [Note] InnoDB: Uses event mutexes
2023-12-03T10:12:23.910103Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2023-12-03T10:12:23.910802Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-12-03T10:12:23.911354Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2023-12-03T10:12:23.912817Z 0 [Note] InnoDB: Number of pools: 1
2023-12-03T10:12:23.913570Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-12-03T10:12:23.914403Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 0
2023-12-03T10:12:23.915132Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-12-03T10:12:23.915812Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-12-03T10:12:23.916388Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-12-03T10:12:23.917012Z 0 [ERROR] Failed to initialize builtin plugins.
2023-12-03T10:12:23.917546Z 0 [ERROR] Aborting

解决历程

1. 修改过配置文件 我已经在my.ini里面配置了 tmpdir=C:/ProgramData/MySQL/MySQL Server
   5.7/tmp
2. 更改过相关文件权限：完全控制
3. 检查过ibdata1文件

都试过了还是不行。

最终解决方法

保存数据库文件主要是data文件夹，卸载mysql服务，依然使用旧的my.ini重新初始化安装。

D:\Mysql\mysql-5.7.30-winx64\bin>mysqld --initializeD:\Mysql\mysql-5.7.30-winx64\bin>mysqld --install
Service successfully installed.

用旧的data文件替换新的，这样数据也不丢失。问题也很快解决。

这篇关于MYSQL报错 [ERROR] InnoDB: Unable to create temporary file； errno: 0的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---