本文摘自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 buff