Question

Wordpress Mysql Connection to new Droplet with Ubuntu 16

Hello i have a droplet (ubuntu 14) where configured VHOST on Lamp with few wordpress sites.

Actually all working correctly, but adding back-end new user, comments and other operation cause Wordpress slowdowns, so i decide to add database on new droplet.

So i configured a new Ubuntu 16 droplet with ONE CLICK APP Lamp and test connect one of my wordpress site to Mysql after created new db user and upload db.

Site not connect, time out error…?

Please, can help me Thank you!

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

By default MySQL will not listen on the public interface so you’ll have to adjust the configuration so your web server with WordPress can reach it. I would recommend enabling private networking on both droplets and setting bind-address in the my.cnf on your database droplet to the private network IP. Then restart MySQL. This should get you up and running though you may want to look into additional steps to secure the data passing between the two droplets.

To start fresh, this guide will walk you through the whole process.