I have two servers both running mysql on Ubuntu 12.04.
I have an application on Server A which has to connect to Server B's database.
I have opened the my.conf file on server B and make the following edit:
#bind-address = 127.0.0.1
Is there anything else I need to do? I still cant seem to connect.
Interestingly, I cant connect to Server B's database using the standard settings in my sql client software (Sequel Pro). I can however, connect to server B's database using Sequel Pro when using the SSH options.
Are there some security settings I need to disable?