Question
How to connect a one click install wordpress to a database on one click install phpmyadmin droplet
- Posted February 27, 2021
- WordPress
I have a one-click install phpmyadmin droplet with the database I want my wordpress to use. My wordpress is a one-click install as well.
I’m tryign to edit the wp-config.php file with the database credentials. What would the hostname be for my case? Is it phpmyadmin droplet’s ip address with port number example 123.456.789:3306?
I can’t seem to get the “error establishing database connection”
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!
Sign in to AnswerThese 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.
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
Hi there,
In order to be able to do that you would need to configure your MySQL server to accept external connections as per this tutorial here:
https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
As an alternative, I could suggest installing PHPmyAdmin on your WordPress Droplet manually as described here:
https://www.digitalocean.com/community/questions/how-to-install-manually-phpmyadmin-on-ubuntu
That way you will not have to open the MySQL service for external connections.
Hope that this helps. Regards, Bobby