如何解决"[ERROR] InnoDB:文件操作中的操作系统错误号87"?在MySQL上? [英] How can I solve "[ERROR] InnoDB: Operating system error number 87 in a file operation" on mysql?

问题描述

当我运行:mysqld --initialize时，在DESKTOP-HU2DG1T.err文件上存在如下错误:

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.

我正在安装mysql zip文件.我从这里遵循youtube教程: https://www.youtube.com/watch?v=CQmeFT81o_0

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

如何解决该错误?

推荐答案

尝试重新提取zip文件，并确保设置(路径)正确.我怀疑您在Windows中的写特权或您的路径设置不正确，但也许是错误的.

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.

这篇关于如何解决"[ERROR] InnoDB:文件操作中的操作系统错误号87"?在MySQL上?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！