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
- 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 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 !!!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.