Report this

What is the reason for this report?

ManageWP & Database Connection to a Droplet.

Posted on June 5, 2018

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:

  1. Ensured proper permissions for users and database
  2. Opened up 3306 port
  3. Changed listen server to 0.0.0.0
  4. 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



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!

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.

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 

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.