Well-Known Member
Sep 6, 2001

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)[email protected]
    Fetching (1)[email protected]%......Done
    Fetching (0)[email protected]
    Fetching (1)[email protected]%......Done
    Sync Source:
    Fetching (0)[email protected]
    Fetching (1)[email protected]%......Done
    Fetching (0)[email protected]
    Fetching (1)[email protected]%......Done
    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?



Dec 4, 2007
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.