PhPmyadmin MySQL 错误 #1018 Xampp
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/42033926/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PhPmyadmin MySQL Error #1018 Xampp
提问by Jabbar Abdul
I have Installed Xampp and configured MySQL and PhPmyadmin through it. BUt, when Itry creating a new User account It shows a MySQL error#1018 which says,
我已经安装了 Xampp 并通过它配置了 MySQL 和 PhPmyadmin。但是,当 Itry 创建一个新的用户帐户时,它显示了一个 MySQL 错误#1018,它说,
Error: 1018 SQLSTATE: HY000 (ER_CANT_READ_DIR)
Message: Can't read dir of '%s' (errno: %d - %s)
错误:1018 SQLSTATE: HY000 (ER_CANT_READ_DIR)
消息:无法读取“%s”的目录(错误号:%d - %s)
this Message takes me to SQL Query in the PHPmyadmin server which shows this,
此消息将我带到 PHPmyadmin 服务器中的 SQL 查询,它显示了这一点,
SHOW PLUGINS SONAME LIKE '%_password_check%'
I am stuck with this. I have tried different things but In vain. I will appreciate help regarding this Issue. Thanks in advance.
我坚持这一点。我尝试了不同的东西,但徒劳无功。我将感谢有关此问题的帮助。提前致谢。
回答by Tihauan
If you installed XAMPP in the default folder C:\xampp
go and manually create the folder C:\xampp\mysql\lib\plugin
in Explorer. This should fix the user creation issue.
如果您在默认文件夹中安装了 XAMPP,C:\xampp
请C:\xampp\mysql\lib\plugin
在资源管理器中手动创建该文件夹。这应该可以解决用户创建问题。
回答by Mohtisham Zubair
This error is showing that you can not read in this directory. Please check this on mysql site
此错误表明您无法读取此目录。请在 mysql 站点上查看此内容
Normally it happens when you do not have rights on the folder, easiest is that you should give full control to "Everyone" group. Just right click on folder and in security tab "edit" and select "Everyone group" and in the lower window give check on Full control.
通常,当您对文件夹没有权限时会发生这种情况,最简单的方法是您应该完全控制“所有人”组。只需右键单击文件夹和安全选项卡中的“编辑”并选择“所有人组”,然后在下方窗口中检查完全控制。