Question

ManageWP & Database Connection to a Droplet.

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

Show comments

Submit an answer

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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