Setup Remote MYSQL Server

[CoolMike]

Hi

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 194.150.249.166 as the access ip
    Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.lock (0)....@69.73.140.17......connected......receiving......Done
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.bz2 (1)....@69.73.140.17......connected......receiving...100%......Done
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.lock (0)....@69.73.140.17......connected......receiving......Done
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.bz2 (1)....@69.73.140.17......connected......receiving...100%......Done
    Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.lock (0)....@69.73.140.17......connected......receiving......Done
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.bz2 (1)....@69.73.140.17......connected......receiving...100%......Done
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.lock (0)....@69.73.140.17......connected......receiving......Done
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.bz2 (1)....@69.73.140.17......connected......receiving...100%......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/mysqld.pid --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/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock) running as mysql with PID 10024

    mysql started ok

Done
Testing new mysql setup...Failed to connect to the remote mysql host:

/usr/bin/mysqladmin: connect to server at '222.222.222.222' 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?

Thanks
Michael

[mhmjr]

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.

--Mike