当我尝试通过 http://localhost/xampp 主页使用 phpmyadmin 时，它拒绝我的访问
我使用的是运行 mac os x 版本 10.5.8 的 Mac 笔记本电脑，我需要将数据库导出到 .sql 文件，以便我可以将其推送到 github 进行项目。但是，当我尝试通过 localhost 主页使用 phpmyadmin 时，当我单击链接时，它会返回一个仅包含以下错误消息的页面：
MySQL said:
1045 - Access Beenied for user 'root'@'localhost' (using passwd) : NO)
phpMyAdmin 尝试连接到 MySQL 服务器，但服务器拒绝了连接。您应该检查配置中的主机、用户名和密码，并确保它们与 MySQL 服务器管理员提供的信息相对应。
但它甚至不提示您输入用户信息？我有什么遗漏的吗？请有人帮忙
I am using a mac laptop running mac os x version 10.5.8 and I need to export a database to an .sql file so I can push it to github for a project. However when I attempt to use phpmyadmin for this through the localhost homepage, when I click on the link it responds with a page with just this error message:
MySQL said:
1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
But it doesn't even prompt you for user information to begin with? is there something I am missing? someone please help
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
问题出在服务器上的 phpmyadmin 配置中。
您可以在此处查看文档：http://www.phpmyadmin.net/documentation/#setup_script
您要查找的设置是“$cfg['Servers'][$i]['auth_type']” - 将其设置为“HTTP”，您将能够输入用户名和密码。
The problem is in your phpmyadmin configuration on the server.
You can see the documentation here: http://www.phpmyadmin.net/documentation/#setup_script
The setting you are looking for is "$cfg['Servers'][$i]['auth_type']" - set this to 'HTTP', and you will be able to input a username and password.
要解决上述错误：-
a) 从 WAMP 服务器的托盘中打开 Mysql 控制台
b) 它会要求输入密码（当你在系统中安装 MySql 时，你可能已经设置了这个密码）（在我的例子中是 admin）
c ）输入管理员（按回车键）
现在这意味着您的 phpmyadmin 假设您的 MySql 没有密码并且无法连接 MySql，但您可以通过提供密码来连接您的 MySql 服务器
从以下路径打开 config.inc 文件
C:\wamp\apps\phpmyadmin4.1.14
并替换此行
$cfg['Servers'][$i]['password'] =' ';
到 `$cfg['服务器'][$i]['密码'] = 'admin';
我希望它能起作用..
To resolve the above error:-
a) Open Mysql console from the tray of WAMP server
b) It will ask for password(you might have set this password earlier when u installed MySql in your system)(In my case it is admin)
c) Enter admin (press enter)
Now it means your phpmyadmin is assuming no password for your MySql and unable to connect MySql but yor are able to connect your MySql Server by providing password
For this Open config.inc file from the below path
C:\wamp\apps\phpmyadmin4.1.14
And replace this line
$cfg['Servers'][$i]['password'] =’ ’;
to `$cfg['Servers'][$i]['password'] = 'admin';
I hope it will work..
关闭防火墙，然后连接到 phpmyadmin。它应该打开。然后再次打开防火墙。为我工作。
Turn off your Firewall and then connect to phpmyadmin. It should open. Then turn on Firewall again. Worked for me.