mysql报错2_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.)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值