用ip地址远程登录mysql_MySQL-使用IP地址连接到远程服务器

最新推荐文章于 2022-09-16 11:40:48 发布

乐游西奥

最新推荐文章于 2022-09-16 11:40:48 发布

阅读量213

点赞数

文章标签：用ip地址远程登录mysql

本文链接：https://blog.csdn.net/weixin_42515331/article/details/113141238

版权

I am using PHP and MySQL to make a database connection, the only change is that I am trying to access my remote server from my local computer using my server IP address.

mysql_connect("x.xx.xx.x","username","password") or die(mysql_error());

and the error I am getting is Unable to connect to the given host. The user has all privileges and rights.

解决方案

Most default installs of MySQL only listen to the local machine.

Look for the bind-address setting in my.cnf on the server, and make sure it's listening on the IP address you're targetting. You may also need to ensure skip-networking isn't switched on!

Alternatively (and less securely!) the following will set it up to listen on all addresses - local and remote:

bind-address = 0.0.0.0