Hello, I tried to set up a separate remote wordpress DB last year and after 2 weeks of being unable to get it working, I stopped. I now have to try again as I really need it. I have read for several days again all tutorials but I am missing something which still does not let it work, hopefully someone can guide me.
Reference: Webserver = Wordpress Droplet / DB Server = Separate Droplet
Originally all was in one droplet that I had for 3 years, since the old droplets are not automatically in VPC like the new droplets, I snapshot it, created new droplet, all works well. So far, everything still one droplet.
I created a brand new droplet ( DB Server ), used the one-click Mysql install so all is configured, went thru some settings as instructed and works fine, I can access Myphpadmin with the Ip address/myphpadmin, I add users as instructed on the tutorials, I test the access…So on DB Server from the console, I use mysql u-username -p and perfect, the user I set up can log in, then I use console from Web-server, use the same login information with the host IP address that user access. Okay, perfect, so I know the DB Server allows Webserver to login with that user.
I take the Webservers database and export it, import it into the Db server, all shows up, the Db server is the same, exact DB name, tables, names, etc. Its a replica as if I was looking at the other one
I change my Wordpress Server config file with the new info like the DB Host Ip address etc and no connection, I have trouble shot just about everything over and over.
The only thing I can think of is does the DB Droplet which only has an IP address assigned to it, no domain, need to have any DNS settings on it? If so, is there a guide for remote DB dns settings with only IP no domain name?
I did do a SHOW VARIABLES WHERE Variable_name = ‘hostname’; and it shows the DB Droplet name, maybe that needs to say the IP address?
Here is the trouble shooting I have done:
I think it might be the DNS settings, like the Domain trying to reach the IP but no DNS setting, I did add a NS record pointing the IP to the DO servers.
Thank You, any help would be appreciated
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.
Click below to sign up and get $100 of credit to try our products over 60 days!