ManageWP & Database Connection to a Droplet.

June 5, 2018 253 views
MySQL Ubuntu 16.04

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

1 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 
Have another answer? Share your knowledge.