开发者社区> 问答> 正文

mysql 启动报错--发现系统错误2,系统找不到指定的文件。?报错

@红薯 你好,想跟你请教个问题:

求大神帮我

.err错误日志如下

2017-07-25T13:13:41.064313Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-07-25T13:13:41.064313Z 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.
2017-07-25T13:13:41.067325Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.18-log) starting as process 15604 ...
2017-07-25T13:13:41.089376Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-07-25T13:13:41.173602Z 0 [Note] InnoDB: Uses event mutexes
2017-07-25T13:13:41.174603Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-07-25T13:13:41.175608Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-07-25T13:13:41.176611Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2017-07-25T13:13:41.179618Z 0 [Note] InnoDB: Number of pools: 1
2017-07-25T13:13:41.180620Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-07-25T13:13:41.185633Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2017-07-25T13:13:41.187640Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-07-25T13:13:41.219725Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-07-25T13:13:41.293924Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-07-25T13:13:41.294925Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-07-25T13:13:41.411235Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2017-07-25T13:13:41.414241Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-07-25T13:13:41.415243Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-07-25T13:13:41.416246Z 0 [Note] InnoDB: Waiting for purge to start
2017-07-25T13:13:41.554615Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2536203
2017-07-25T13:13:41.556622Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-07-25T13:13:41.556622Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2017-07-25T13:13:41.567682Z 0 [Note] Plugin mysqlx reported: 'Scheduler "work" started.'
2017-07-25T13:13:41.568655Z 0 [Note] Plugin mysqlx reported: 'Scheduler "network" started.'
2017-07-25T13:13:41.577702Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170725 21:13:41
2017-07-25T13:13:41.577702Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-07-25T13:13:41.580710Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-07-25T13:13:41.583694Z 0 [Note] IPv6 is available.
2017-07-25T13:13:41.583694Z 0 [Note]   - '::' resolves to '::';
2017-07-25T13:13:41.584696Z 0 [Note] Server socket created on IP: '::'.
2017-07-25T13:13:41.636861Z 0 [Note] Event Scheduler: Loaded 0 events
2017-07-25T13:13:41.637839Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.18-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2017-07-25T13:13:41.640876Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 
2017-07-25T13:13:41.643880Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-07-25T13:13:41.683959Z 0 [Note] End of list of non-natively partitioned tables
2017-07-25T13:13:41.828352Z 0 [Note] Plugin mysqlx reported: 'Neither MySQL Server nor Mysqlx Plugin has valid SSL configuration'
2017-07-25T13:13:41.830351Z 0 [Warning] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'
2017-07-25T13:13:41.832355Z 0 [Note] Plugin mysqlx reported: 'For more information, please see the Using Secure Connections with X Plugin section in the MySQL documentation.'
2017-07-25T13:13:41.834386Z 0 [Note] Plugin mysqlx reported: 'IPv6 is available'
2017-07-25T13:13:41.836391Z 0 [Note] Plugin mysqlx reported: 'X Plugin listens on TCP (bind-address:'::', port:33060)'
2017-07-25T13:13:41.837368Z 0 [Note] Plugin mysqlx reported: 'Server starts handling incoming connections'
2017-07-25T13:13:42.412899Z 4 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2017-07-25T14:53:56.849487Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 770158ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-07-25T18:36:25.805348Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10800230ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-07-26T03:09:18.782977Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30764944ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-07-26T03:21:22.211861Z 9 [Note] Aborted connection 9 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-07-26T03:34:08.264613Z 10 [Note] Aborted connection 10 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-07-26T06:44:26.827727Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7609200ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-07-26T08:05:39.086370Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 2440247ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

展开
收起
爱吃鱼的程序员 2020-06-08 12:15:09 697 0
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    说的很清楚了啊

    TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption

    还有

    'NO_ZERO_DATE','NO_ZERO_IN_DATE'and'ERROR_FOR_DIVISION_BY_ZERO'sqlmodesshouldbeusedwithstrictmode.Theywillbemergedwithstrictmodeinafuturerelease.

    2020-06-08 12:15:21
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像