By Hoatuoi9x
Hi everyone,
I installed wordpress on my UBUNTU droplet and my live website is running from there with the standard wp-config define( ‘DB_HOST’, 'localhost’ ); If I change these settings to my DO Database connection it takes me to the WP installation page. So, wondering do I import my wordpress.sql(I got from pypmyadmin export) file? I’ve also tried connecting through the console with Mysql with connection details and reports 2003 'can’t connect to mysql server’ I also have the MySQL shell installed if that helps. I have changed the password to 'Legacy’ as I see that has caused some problems for others.
Not sure what to do other than reinstall wordpress and recover backup? is it not possible to just add the tables and data to the new connection?
thanks very much
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!
Hey there!
I think in this case it may be best to import that phpmyadmin export into your managed database first. You can then make the connection change in your Wordpress settings. To import that database into your managed database you can follow this guide: How to Import MySQL Databases into DigitalOcean Managed Databases There is also a full guide on using Wordpress with managed databases that may be helpful as well: How To Install WordPress with a Managed Database on Ubuntu 18.04
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 SMBs
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.