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
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 !!!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
On your remote MySQL installation find your configuration file – may be
/etc/my.cnf
depending on your installation choiceSet 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