很长时间没有用数据库了,之前在电脑上安装了mysql,但是许久不用,最近用起来却是问题多多,提示无法启动服务器, 却没有报任何错误。使用net start mysql 启动服务提示如下图:
使用mysql –console命令查看错误信息。如下:
D:\Program Files (x86)\mysql\bin>mysqld –console
2018-01-27T07:04:33.136066Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2018-01-27T07:04:33.136066Z 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.
2018-01-27T07:04:33.136066Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2018-01-27T07:04:33.136566Z 0 [Note] –secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-01-27T07:04:33.137072Z 0 [Note] mysqld (mysqld 5.7.16) starting as process 8304 …
2018-01-27T07:04:33.153080Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-01-27T07:04:33.155586Z 0 [Note] InnoDB: Uses event mutexes
2018-01-27T07:04:33.158582Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-01-27T07:04:33.162091Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-01-27T07:04:33.166087Z 0 [Note] InnoDB: Number of pools: 1
2018-01-27T07:04:33.168093Z 0 [Note] InnoDB: Not using CPU crc32 instructions
201