sesc360 sesc360 - 2 years ago 258
SQL Question

mysql bind address bind to localhost

I setup a remote database server on digital ocean. I use this server to connect different VPS to this server and save the data separately. This works very well. But I do not know how to connect properly via sequelPro to this server now, as I needed to adjust the my.cnf file on the server to adjust the bind address.

When I set the bind_address to I can connect perfectly well to the server via this config:

enter image description here

But if I do this, I cannot connect anymore to the remote server from my other droplet, as the server IP of the DB VPS is now set to and not to the remote server IP address.

How can I fix this?

Answer Source

You can bind it to which binds to all addresses. Change the default port number to something large that people would keep guessing and that should help.

Also security is determined by the way you harden your application which is your database server. As long as you have strong password that should take care of your security concerns.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download