dblose_ja 2014-09-01 06:17 采纳率: 0%
浏览 1438

启动mysql服务报ERROR:1067错误

这里是日志:
2014-09-01T06:12:49.816554Z 0 [Note] Plugin 'FEDERATED' is disabled.
2014-09-01T06:12:49.818554Z 0 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-01T06:12:49.820554Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-01T06:12:49.822554Z 0 [Note] InnoDB: Uses system mutexes
2014-09-01T06:12:49.824554Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-01T06:12:49.825555Z 0 [Warning] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2014-09-01T06:12:49.830555Z 0 [Note] InnoDB: Number of pools: 1
2014-09-01T06:12:49.832555Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-01T06:12:49.834555Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 2
2014-09-01T06:12:49.835555Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2014-09-01T06:12:49.837555Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-09-01T06:12:49.840555Z 0 [ERROR] Unknown/unsupported storage engine: innodb
2014-09-01T06:12:49.841555Z 0 [ERROR] Aborting

2014-09-01T06:12:49.842556Z 0 [Note] Binlog end
2014-09-01T06:12:50.010565Z 0 [Note] Shutting down plugin 'partition'
2014-09-01T06:12:50.015565Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-09-01T06:12:50.021566Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-09-01T06:12:50.027566Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-09-01T06:12:50.033566Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-09-01T06:12:50.039567Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-09-01T06:12:50.043567Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-09-01T06:12:50.045567Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-09-01T06:12:50.048567Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-09-01T06:12:50.050567Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-09-01T06:12:50.052568Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-09-01T06:12:50.054568Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-09-01T06:12:50.057568Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-09-01T06:12:50.059568Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-09-01T06:12:50.061568Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-09-01T06:12:50.064568Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-09-01T06:12:50.066568Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-09-01T06:12:50.068568Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2014-09-01T06:12:50.071569Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2014-09-01T06:12:50.073569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-09-01T06:12:50.074569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-09-01T06:12:50.076569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-09-01T06:12:50.078569Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-09-01T06:12:50.079569Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-09-01T06:12:50.081569Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-09-01T06:12:50.083569Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-09-01T06:12:50.084569Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-09-01T06:12:50.086569Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2014-09-01T06:12:50.087570Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-09-01T06:12:50.089570Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-09-01T06:12:50.091570Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2014-09-01T06:12:50.092570Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2014-09-01T06:12:50.094570Z 0 [Note] Shutting down plugin 'ARCHIVE'
2014-09-01T06:12:50.096570Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2014-09-01T06:12:50.097570Z 0 [Note] Shutting down plugin 'MyISAM'
2014-09-01T06:12:50.099570Z 0 [Note] Shutting down plugin 'MEMORY'
2014-09-01T06:12:50.100570Z 0 [Note] Shutting down plugin 'CSV'
2014-09-01T06:12:50.101570Z 0 [Note] Shutting down plugin 'sha256_password'
2014-09-01T06:12:50.103570Z 0 [Note] Shutting down plugin 'mysql_old_password'
2014-09-01T06:12:50.105571Z 0 [Note] Shutting down plugin 'mysql_native_password'
2014-09-01T06:12:50.107571Z 0 [Note] Shutting down plugin 'binlog'
2014-09-01T06:12:50.108571Z 0 [Note] F:\mysqlpath\MySQL\MySQL Server 5.7\bin\mysqld: Shutdown complete

有谁知道的吗?谢谢。。。

  • 写回答

1条回答 默认 最新

  • 甲柒 2024-03-05 12:48
    关注

    检查权限:

    确保MySQL服务器运行的用户(在Windows上通常是"MySQL")具有在其数据目录中创建文件的权限。你可以通过右键点击数据目录,选择“属性”,然后在“安全”选项卡下检查权限。
    如果需要,你可以更改数据目录的权限,允许MySQL服务器运行的用户进行读写操作。
    检查磁盘空间:

    确保你的磁盘上有足够的空间来创建临时文件。如果磁盘空间不足,MySQL可能无法创建临时文件。
    检查临时文件夹:

    有时,MySQL可能尝试在系统的临时文件夹中创建文件。你可以检查这个文件夹的权限和磁盘空间。在Windows上,这个文件夹通常是C:\Windows\Temp或C:\Users\YourUsername\AppData\Local\Temp\。
    检查MySQL配置:

    查看MySQL的配置文件(通常是my.ini或my.cnf),检查是否有任何与InnoDB或临时文件相关的配置,例如innodb_temp_data_file_path。
    重新启动MySQL服务:

    在进行上述更改后,尝试重新启动MySQL服务,看看问题是否得到解决。

    评论

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果