Trying to get Droplet in NYC2 on MySQL to access tables on MySQL droplet in Amsterdam

February 27, 2018 557 views
MySQL PHP Ubuntu
greg36bd0d6b281
By:
greg36bd0d6b281

I have two droplets - one in Amsterdam (5.101.98.143) and one in NYC2 (192.241.185.178) - 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

  1. 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
  2. I set up FW rules (which i have now deleted) allowing BOTH servers incoming and outgoing on port 3306
  3. I tried to create a new user on MySQL in Amsterdam but that i could not get right.
  4. 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 rendercast@192.241.185.178 not allowed to access dbase

Having spent over 5 hours last night on this - I now am requesting help please !!!!

Log In to Comment
1 Answer
jasonjpeters February 27, 2018

On your remote MySQL installation find your configuration file – may be /etc/my.cnf depending on your installation choice

Set bind-address to – bind-address=YOUR-SERVER-IP
..or..
Set bind-address to – bind-address=0.0.0.0 – This listens on all interfaces.

Make sure to remove or comment out skip-networking

Log into mysql and create a new user - replace red values

CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%';
FLUSH PRIVILEGES;

exit

If you have any firewalls running, be sure to open port 3306

Reply
Have another answer? Share your knowledge.

Related Questions