The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Setup Remote MYSQL Server

Discussion in 'General Discussion' started by CoolMike, Feb 4, 2010.

  1. CoolMike

    CoolMike Well-Known Member

    Sep 6, 2001
    Likes Received:
    Trophy Points:

    I try to setup a remote mysql server on a standard centos installation. I installed already mysql and perl on this server and then tried the function in WHM to setup the remote server. But I get the following error message:

    Using Remote mySQL Server
    Fetching password from remote mysql server.... Copying mysql configuration from remote host.....0%.. ..100%.. ...Done
    ...password set in /root/.my.cnf on remote server, it will be used...Done
    Generating Setup Script....Done
    Copying MySQL Script.....0%.. ..100%.. ...Done
    Running MySQL Script...
        Using as the access ip
        Sync Source:
        Fetching (0)....@
        Fetching (1)....@
        Fetching (0)....@
        Fetching (1)....@
        Sync Source:
        Fetching (0)....@
        Fetching (1)....@
        Fetching (0)....@
        Fetching (1)....@
        Waiting for mysql to restart..............finished.
        mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/ --user=mysql) running as root with PID 9974
        mysqld (/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/ --skip-external-locking --socket=/var/lib/mysql/mysql.sock) running as mysql with PID 10024
        mysql started ok
    Testing new mysql setup...Failed to connect to the remote mysql host:
    /usr/bin/mysqladmin: connect to server at '' failed
    error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 113'
    Is there any special configuration or missing configuration on my side?

  2. mhmjr

    mhmjr Member

    Dec 4, 2007
    Likes Received:
    Trophy Points:
    I'm not sure if you got an answer to your question, I see you posted this some time ago. However, I just had the same problem and it took me awhile to figure out what was wrong and I had run across this post while researching. In my case, the problem was incorrect data existing in /root/.my.cnf on the SQL server. The user/pass should be in there in plain text, the password I saw in mine looked like a hash of a password. I updated that file with the SQL servers root pass and then WHM was able to connect to it and authenticate. Hope that saves someone some time.


Share This Page