mysql5.7.22打不开_windows下mysql-5.7.22-winx64突然启动不了，报错Could not open log file

本文摘自classinstance.cn。

windows下mysql-5.7.22-winx64突然启动不了，感觉启动几秒钟后就自己关闭了，看了下启动日志：

2019-08-25T10:57:08.389404Z 0 [Warning] option 'wait_timeout': unsigned value 31536000 adjusted to 2147483

2019-08-25T10:57:08.389459Z

0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please

use --explicit_defaults_for_timestamp server option (see documentation

for more details).

2019-08-25T10:57:08.389478Z 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.

2019-08-25T10:57:08.389481Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.

2019-08-25T10:57:08.389501Z

0 [Note] --secure-file-priv is set to NULL. Operations related to

importing and exporting data are disabled

2019-08-25T10:57:08.390232Z 0 [Note] mysqld.exe (mysqld 5.7.22-log) starting as process 320 ...

2019-08-25T10:57:08.530990Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2019-08-25T10:57:08.531628Z 0 [Note] InnoDB: Uses event mutexes

2019-08-25T10:57:08.532009Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier

2019-08-25T10:57:08.532526Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3

2019-08-25T10:57:08.534128Z 0 [Note] InnoDB: Number of pools: 1

2019-08-25T10:57:08.534711Z 0 [Note] InnoDB: Not using CPU crc32 instructions

2019-08-25T10:57:08.538911Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2019-08-25T10:57:08.545756Z 0 [Note] InnoDB: Completed initialization of buffer pool

2019-08-25T10:57:08.734599Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2019-08-25T10:57:10.619901Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2019-08-25T10:57:10.620953Z

0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically

writing the file full; Please wait ...

2019-08-25T10:57:10.789058Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.

2019-08-25T10:57:10.792190Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2019-08-25T10:57:10.792835Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2019-08-25T10:57:10.793873Z 0 [Note] InnoDB: Waiting for purge to start

2019-08-25T10:57:10.859530Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 602744911

2019-08-25T10:57:10.860725Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\myTools\mysql-5.7.22-winx64\data\ib_buffer_pool

2019-08-25T10:57:10.860891Z 0 [Note] Plugin 'FEDERATED' is disabled.

2019-08-25T10:57:10.954845Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190825 18:57:10

mysqld: File '2019-08-25T10:35:51.589934Z 0 [ERROR] Aborting' not found (Errcode: 13 - Permission denied)

2019-08-25T10:57:10.957735Z 0 [ERROR] Failed to open log (file '2019-08-25T10:35:51.589934Z 0 [ERROR] Aborting', errno 13)

2019-08-25T10:57:10.958291Z 0 [ERROR] Could not open log file

2019-08-25T10:57:10.958712Z 0 [ERROR] Can't init tc log

2019-08-25T10:57:10.959075Z 0 [ERROR] Aborting

2019-08-25T10:57:10.959422Z 0 [Note] Binlog end

2019-08-25T10:57:10.959832Z 0 [Note] Shutting down plugin 'ngram'

2019-08-25T10:57:10.960212Z 0 [Note] Shutting down plugin 'partition'

2019-08-25T10:57:10.960698Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2019-08-25T10:57:10.961494Z 0 [Note] Shutting down plugin 'ARCHIVE'

2019-08-25T10:57:10.962015Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2019-08-25T10:57:10.962476Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2019-08-25T10:57:10.962882Z 0 [Note] Shutting down plugin 'MyISAM'

2019-08-25T10:57:10.963274Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2019-08-25T10:57:10.963767Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2019-08-25T10:57:10.964181Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2019-08-25T10:57:10.964666Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2019-08-25T10:57:10.965071Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2019-08-25T10:57:10.965489Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2019-08-25T10:57:10.965868Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2019-08-25T10:57:10.966281Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2019-08-25T10:57:10.966669Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2019-08-25T10:57:10.967091Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2019-08-25T10:57:10.967463Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2019-08-25T10:57:10.967895Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2019-08-25T10:57:10.968304Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2019-08-25T10:57:10.968684Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2019-08-25T10:57:10.969119Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2019-08-25T10:57:10.970031Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2019-08-25T10:57:10.970487Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2019-08-25T10:57:10.970909Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2019-08-25T10:57:10.971326Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2019-08-25T10:57:10.971776Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2019-08-25T10:57:10.972218Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2019-08-25T10:57:10.972656Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2019-08-25T10:57:10.973125Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2019-08-25T10:57:10.973577Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2019-08-25T10:57:10.974052Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2019-08-25T10:57:10.974561Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2019-08-25T10:57:10.975002Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2019-08-25T10:57:10.975544Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2019-08-25T10:57:10.976035Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2019-08-25T10:57:10.976504Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2019-08-25T10:57:10.976921Z 0 [Note] Shutting down plugin 'InnoDB'

2019-08-25T10:57:10.977359Z 0 [Note] InnoDB: FTS optimize thread exiting.

2019-08-25T10:57:10.977888Z 0 [Note] InnoDB: Starting shutdown...

2019-08-25T10:57:11.082157Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\myTools\mysql-5.7.22-winx64\data\ib_buffer_pool

2019-08-25T10:57:11.085055Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190825 18:57:11

2019-08-25T10:57:12.317633Z 0 [Note] InnoDB: Shutdown completed; log sequence number 602744930

2019-08-25T10:57:12.318944Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2019-08-25T10:57:12.319430Z 0 [Note] Shutting down plugin 'MEMORY'

2019-08-25T10:57:12.319937Z 0 [Note] Shutting down plugin 'CSV'

2019-08-25T10:57:12.320401Z 0 [Note] Shutting down plugin 'sha256_password'

2019-08-25T10:57:12.320953Z 0 [Note] Shutting down plugin 'mysql_native_password'

2019-08-25T10:57:12.321609Z 0 [Note] Shutting down plugin 'binlog'

2019-08-25T10:57:12.341979Z 0 [Note] mysqld.exe: Shutdown complete

查看了下别人解决方案说是可以删除binglog日志后重启就可以，我试着先备份如下日志：

然后把data下的这些日志删除了(ibdata1除外，这个删除了数据表会找不到)，重启mysql，可以了，另外启动时最好用管理员身份启动，免得出错。

欢迎分享，(木庄网络博客交流QQ群：562366239)