phpmyadmin Mysql 错误
我有 Debian 服务器。
我的 phpmyadmin 和 mysql 通过命令行早些时候运行良好。 但突然我在访问 phpmyadmin 时收到此错误。
2003 - 服务器没有响应
，当我尝试通过命令行访问时
mysql -u userid -p
Enter password:
ERROR 1045 (28000): Access denied for user 'userid'@'localhost' (using password: YES)
，当我通过此访问时，
mysql -h ipaddress -u userid -p
需要很长时间才能连接。
I have debian server.
My phpmyadmin & mysql through command line was earlier working well.
But suddenly i am getting this error while accessing phpmyadmin.
2003 - The server is not responding
And when i try to access through command line
mysql -u userid -p
Enter password:
ERROR 1045 (28000): Access denied for user 'userid'@'localhost' (using password: YES)
And when i access through this
mysql -h ipaddress -u userid -p
it takes very long time to connect.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
您可以检查 my.ini 中的“bind-address”与 config.inc.php（phpMyAdmin 的）中的 $cfg['Servers'][$i]['host'] 值是否匹配。 如果没有，请将它们或两者都更改为“localhost”以仅本地主机访问或服务器的真实IP地址以从其他主机访问。
You can check or the 'bind-address' in my.ini and the $cfg['Servers'][$i]['host'] value in config.inc.php (of phpMyAdmin) match. If not, change them or both to 'localhost' for only localhost access or the real ip address of the server for access from other hosts.
mysql 日志有没有说明这个错误？
Does the mysql log say anything about this error?
检查 config.inc.php 中的 mysql 用户名和密码是否与您在 mysql 配置文件中设置的内容匹配。 如果您无法使其正常工作，您可能需要询问您的网络托管服务商。
Check if the mysql username and password in
config.inc.phpmatch what you've set in your mysql configuration file. If you can't get it working you may want to ask your web host.用户通常收到此错误的原因之一是因为他们的防火墙配置不正确，并且不允许传出连接到 3306 等端口（这种情况在我身上发生过不止一次）。 请检查您是否属于这种情况。
One of the reasons users generally get this error is because their firewall is not properly configured and does not allow an outgoing connection to ports like 3306 (This has happened to me more than once). Please check if that is the case with you.