MySQL 对 wamp 服务器 phpmyadmin 没有权限
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18420470/
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
No privileges on wamp server phpmyadmin
提问by Madizm
I installed WAMP on Windows 8, and I'm having problems with MySQL privileges in phpMyAdmin.
我在 Windows 8 上安装了 WAMP，但我在 phpMyAdmin 中遇到了 MySQL 权限问题。
Here, you can see the screenshot:
在这里，您可以看到屏幕截图：
As you can see, there is no privileges tab, and I can't a create new database.
如您所见，没有权限选项卡，我无法创建新数据库。
回答by Muhammad Usman Ghani
[SOLUTION 1]
[解决方案1]
[CLICK ON USER ACCOUNTS][1]
[CLICK ON YOUR USER ACCOUNT WHICH SHOW NO PRIVILEGES[2]
`[2]: https://i.stack.imgur.com/MEMEY.png[3] [CLICK ON EDIT PRIVILEGES AND TICK ALL THE CHECKBOXES] enter image description here
`[2]: https://i.stack.imgur.com/MEMEY.png[3] [点击编辑权限并勾选所有复选框] 在此处输入图片描述
回答by Deepak Sukumar
Go to phpmyadmin webpage under user accounts tab and check if the root has all_privileges
转到用户帐户选项卡下的 phpmyadmin 网页并检查 root 是否具有 all_privileges
and still if you are not able create db
并且仍然如果您无法创建数据库
Go to mysql console login as root and type: flush privileges;
以 root 身份进入 mysql 控制台登录并输入：flush privileges;
now reload phpmyadmin page and you should be in synch
现在重新加载 phpmyadmin 页面，您应该处于同步状态
回答by Maryam
i just write UserName root and leave the password blank it work for me
我只是写 UserName root 并将密码留空它对我有用
回答by user2938457
for no priviledge error, the solution is this:
对于没有特权错误，解决方案是这样的：
It is not a file permission issue, the mysql user you logged in as doesn't have the right to create databases. You need to login as root for full permission, which I understand you are not. If I am not mistaken, the default password for "root" is empty (blank, nothing, ""), so try that. Once you are logged in as root in phpMyAdmin, you will be able to create databases or create another user with full permission.
这不是文件权限问题，您登录的 mysql 用户无权创建数据库。您需要以 root 身份登录以获得完全权限，我知道您不是。如果我没记错的话，“root”的默认密码是空的（空白，没有，“”），所以试试吧。在 phpMyAdmin 中以 root 身份登录后，您将能够创建数据库或创建另一个具有完全权限的用户。
kudos to:: http://www.theadminzone.com/forums/showthread.php?t=98676
感谢：http: //www.theadminzone.com/forums/showthread.php?t=98676
回答by user10056588
Your problem is your authentication. If you are accessing phpMyAdmin through WAMP, then you need to check the files in WAMP for the proper configuration.
您的问题是您的身份验证。如果您通过 WAMP 访问 phpMyAdmin，那么您需要检查 WAMP 中的文件以获得正确的配置。
回答by SpeedMan86
Hey i just tried this and it worked type the "root" as username and the password you set during installation. Worked
嘿，我刚试过这个，它工作了，输入“root”作为用户名和你在安装过程中设置的密码。工作过
回答by mynetx
You might be able to start the MySQL server with --skip-grant-tablesoption. Then access the Userstab in phpMyAdmin, and delete the password for root@localhostand [email protected].
您可以使用--skip-grant-tables选项启动 MySQL 服务器。然后访问用户选项卡在phpMyAdmin，并删除密码root@localhost和[email protected]。
回答by Husain
you just ned to enter the username as 'root' and leave password blank. You will be able to create database.
您只需输入用户名“root”并将密码留空。您将能够创建数据库。
