By andrew888844
I’m trying to connect my web server (planning to run Wordpress) to my remote database server on a private network, both hosted on Digital Ocean.
I’m currently using Runcloud.io to install LEMP on my servers.
The issue I’m facing is, I can get private networking running fine:
- I can ping my DB server’s private IP
- Running
nc -zv private_ip 3306is successful - Running
mysql -u username -p -h public_ipis successful
Yet when I try connect to mysql (from my web server) using my private ip, I get the following output:
ERROR 1130 (HY000): Host 'webserver_private_ip' is not allowed to connect to this MariaDB server
I set up my private networking using this guide: https://www.digitalocean.com/community/tutorials/how-to-enable-digitalocean-private-networking-on-existing-droplets
Any help in this is greatly appreciated
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!
If you have the ufw firewall enabled, you’ll need an allow rule for the connecting machine’s IP to use 3306 (the default db port)
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.