Trying to get Droplet in NYC2 on MySQL to access tables on MySQL droplet in Amsterdam
I have two droplets - one in Amsterdam (126.96.36.199) and one in NYC2 (188.8.131.52) - the NYC runs wordpress on MySQL and the first is just a Bootstrap app running on MySQL
I am trying the NYC2 droplet to access tables on the Amsterdam droplet. I have tried various options but cannot get the connection to establish
- I removed the bind-address=localhost from myconf as suggested on many articles. allowing the server to listen on all ports on the Amsterdam server
- I set up FW rules (which i have now deleted) allowing BOTH servers incoming and outgoing on port 3306
- I tried to create a new user on MySQL in Amsterdam but that i could not get right.
- I have tried using the same DB connection info eg username/pass/db name etc on NYC2 to connect to the DB on Amsterdam but no go
It just says user email@example.com not allowed to access dbase
Having spent over 5 hours last night on this - I now am requesting help please !!!!