如何使在Xampp上运行的Php应用程序连接到远程mysql数据库？
我有一个在 XAMPP 上运行的 php 应用程序，但我想连接到在远程计算机上运行的 mysql 数据库（也使用 XAMPP）。当我连接到我的计算机上的 mysqldb 实例时，该应用程序工作正常。我已更改配置文件以指向远程数据库，并提供了正确的凭据。但我收到访问被拒绝错误。
I have a php application running on XAMPP but I want to connect to a mysql db running on a remote machine(which is also using XAMPP). The application works fine when I connect to the mysqldb instance on my machine. I have changed the configuration files to point to the remote db and have given the correct credentials as well. But I get access denied error.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
“访问被拒绝”意味着您至少正在连接到远程 MySQL 实例。最有可能的是您的凭据不匹配。您可能已向远程 MySQL 上的“user@somehost”授予权限，但如果该计算机无法通过 DNS 或主机文件查找解析“somehost”，则必须回退到检查“[电子邮件受保护]”帐户。
"Access denied" means you're at least connecting to the remote MySQL instance. Most like you've got a mismatch on the credentials. You may have granted permissions to "user@somehost" on the remote MySQL, but if that machine can't resolve "somehost" via DNS or a Hosts file lookup, it'll have to fall back to checking for a "[email protected]" account.
首先，我会检查远程数据库所有者/主机以确保它们允许外部访问。大多数主机，尤其是共享主机提供商，只允许访问本地运行的脚本，并且不允许允许外部访问，就像您所描述的那样。
First I would check the remote database owner / host to make sure they allow external access. Most hosts, especially shared hosting providers, only allow access to scripts run locally and do not allow external access like you are describing.