Sep 17, 2007
I'm having an issue setting up my cpanel server to use an existing remote MySQL server.

I have created a MySQL user on the remote server and given it the appropriate GRANTS.

I can ssh to the remote server from the cpanel server.
I can also connect to mysql on the remote server with the command:
/usr/local/bin/mysql -u root -h xxx.xxx.xxx.xxx -p
Once connected, running;
use mysql;
select * from user;
gives me the correct results for the remote server.

However, when I try to useWHM to setup the remote server, I get:
Using Remote mySQL Server
Fetching password from remote mysql server.... Copying mysql configuration from remote host......Done
Generating Setup Script....Done

Copying MySQL Script.....0%.. ..100%.. ...Done
Running MySQL Script...
Using aaa.bbb.ccc.ddd as the access ip
Unable to sync: $! at ./updatenow line 59.
Unable to sync: $! at ./updatenow line 59.
/home/myuser/.mysqlscript: /scripts/mysqlup: not found
/home/myuser/.mysqlscript: /scripts/mysqlpasswd: not found
/home/myuser/.mysqlscript: /scripts/fixetchosts: not found
/home/myuser/.mysqlscript: /scripts/restartsrv: not found

Testing new mysql setup...Failed to connect to the remote mysql host:
/usr/local/bin/mysqladmin: connect to server at 'xxx.xxx.xxx.xxx' failed
error: 'Access denied for user 'root'@'blahblah.com' (using password: YES)'

Restoring old mysql config. Please resolve the above error and try again.

It must be something simple, but I can't seem to find it.

Also, the instructions/docs for remote MySQL seem far too simplistic to actually work. Can anyone point me to a detailed step-by-step.

Thank you