ManageWP & Database Connection to a Droplet.

June 5, 2018 665 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 comment
  • An old post but thought we would comment.

    With ManageWP - the easiest way is the backup your current site.

    1. Create a backup of your current website (if you have one).
    2. Create a droplet and install WP - there is one available in the marketplace
    3. Set DNS to the Droplet. Wait a bit.
    4. Check to see if the new location is pulling up.
    5. If it’s pulling up, Reconnect the same website to the new location in ManageWP. This may take several times and you might need to log in manually to the new location and install ManageWP to use the connection key.
    6. Restore the backup

    You might get a few errors such as the ManageWP plugin is not installed or at the end, a SQL error. When this happens, wait a bit.. then just restore the site via FTP through ManageWP and it all should be good to go.

    Hope this helps.

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.