Related

Product Now Available: Managed MySQL Databases Product
install mysql 3.24 on ubuntu 16.04 Question Question
Automatically restart MySQL on Ubuntu 16.04.x - If statement may be wrong? Question Question

Question

ManageWP & Database Connection to a Droplet.

Posted June 5, 2018 1.1k views
MySQLUbuntu 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

Add a comment
InspireWorks
By:
InspireWorks
Add a comment
1 comment
  • townpressmedia July 20, 2019
    Reply Report

    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.

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.

×
1 answer
InspireWorks June 5, 2018

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
Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help