mysql错误码87,如何解决“ [ERROR] InnoDB：文件操作中的操作系统错误号87”？在MySQL上？...

When I run : mysqld --initialize, on the DESKTOP-HU2DG1T.err file exist error like this :

2018-01-30T09:35:35.078489Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-01-30T09:35:35.332914Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.

2018-01-30T09:35:35.334708Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation

2018-01-30T09:35:35.336378Z 0 [ERROR] InnoDB: Cannot continue operation.

I'm installing mysql zip file. I follow youtube tutorial from here : https://www.youtube.com/watch?v=CQmeFT81o_0

How can I solve the error?

解决方案

Try to re-extract your zip file and make sure your setting (path) is correct. I suspect your write privilege in your windows or your path setting is incorrect but maybe wrong.

To few information to me to answer your answer precisely but hope this can answer your question.