mardi 3 février 2015

Mysql: remote and local access


I have a gentoo where is installed a mysql server. I need a remote access to this server, so I have modified the option bind address in the file /etc/mysql/my.cnf bringing it from


bindaddress: 127.0.0.1


to


bindaddress: MY_FOREIGN_IP


And in this way I obtain a remote access to the mysql server.


The problem is that I have a local service that uses 127.0.0.1 ip to talk with my database. If I change the bindaddress option, this service can't reach mysql server anymore.


There is a way to solve this issue, without using ssh tunnel?



Aucun commentaire:

Enregistrer un commentaire