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 127.0.0.1 I can connect perfectly well to the server via this config:
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 127.0.0.1 and not to the remote server IP address.
How can I fix this?
You can bind it to
0.0.0.0 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.