Wordpress Unable to Connect to remote DB over Private Networking

Can you ping the private IP address from the other droplet? How about connecting to the remote database manually:

<pre> mysql -u wordpressuser -h database_server_IP -p </pre>

This article should help point you in the right direction:

https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql

If both of those fail, run ifconfig on the database server. You should see entries for both “eth0” and “eth1” If you don’t then the private network isn’t up at all. In that case, try running:

<pre> ifup eth1 </pre>

pinging works.

I was also able to manually connect using the mysql command, both to the public and private IP.

ifconfig shows both eth0 and eth1

Private IP just won’t work if I try to access from PHP files or wordpress.

Follow up - I don’t know if it was the repeated restarting of mysql or what it was, but I can now connect to 2/3 of my databases using both private and public IPs. However, I get this error when I try to access the 3rd remote DB using the exact same file:

Could not select database: Access denied for user

Thanks for helping with this.