ManageWP & Database Connection to a Droplet.

Question

So this is clearly a very specific answer, but I am sure it would fix problems outside of it as well.

I installed Ubuntu, PHP, MySQL, ProFTPd, Apache, and a few other mods. Got Webmin & Virtualmin all setup and everything is working beautifully. The ONE thing that I cant get to work, which is the one thing that I really need, is to get ManageWP to migrate WordPress sites. I can install it just find, just cant migrate them.

I have entered in my FTP and it works on the site, but it gives me a “Cant connect to database” error with my other information.

Things I have tried:

Ensured proper permissions for users and database
Opened up 3306 port
Changed listen server to 0.0.0.0
And variants of almost all of the above. I have spent about 16 hours doing research and I cant figure this out.

Additionally I tried to connect the same way using other programs with roughly the same results. Clearly its a remote connection issue, but I have tried everything I can think of.

Anyones help would be greatly appreciated.

Thanks

InspireWorks · Answer

I also ran Netstat -plutn and notice that nothing is listening on port 3306. But its open… im so confused. Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 10.10.0.5:53 0.0.0.0:* LISTEN 1700/named tcp 0 0 206.189.199.150:53 0.0.0.0:* LISTEN 1700/named tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 1700/named tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1695/sshd tcp 0 0 127.0.0.1:11000 0.0.0.0:* LISTEN 2049/lookup-domain- tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 2173/master tcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN 1700/named tcp 0 0 0.0.0.0:20000 0.0.0.0:* LISTEN 2077/perl tcp 0 0 0.0.0.0:587 0.0.0.0:* LISTEN 2173/master tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 1741/dovecot tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 1741/dovecot tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN 2177/perl tcp6 0 0 :::21 :::* LISTEN 1876/proftpd: (acce tcp6 0 0 :::53 :::* LISTEN 1700/named tcp6 0 0 :::22 :::* LISTEN 1695/sshd tcp6 0 0 :::25 :::* LISTEN 2173/master tcp6 0 0 ::1:953 :::* LISTEN 1700/named tcp6 0 0 :::443 :::* LISTEN 1909/apache2 tcp6 0 0 :::3306 :::* LISTEN 20531/mysqld tcp6 0 0 :::587 :::* LISTEN 2173/master tcp6 0 0 :::2222 :::* LISTEN 1876/proftpd: (acce tcp6 0 0 :::110 :::* LISTEN 1741/dovecot tcp6 0 0 :::143 :::* LISTEN 1741/dovecot tcp6 0 0 :::80 :::* LISTEN 1909/apache2 udp 0 0 0.0.0.0:20000 0.0.0.0:* 2077/perl udp 0 0 10.10.0.5:53 0.0.0.0:* 1700/named udp 0 0 206.189.199.150:53 0.0.0.0:* 1700/named udp 0 0 127.0.0.1:53 0.0.0.0:* 1700/named udp 0 0 0.0.0.0:10000 0.0.0.0:* 2177/perl udp6 0 0 :::53 :::* 1700/named

Related Questions

Question

ManageWP & Database Connection to a Droplet.

Want to learn more? Join the DigitalOcean Community!

Try DigitalOcean for free

Popular Topics

Questions

Events

Get involved