Remote MySQL problem

[jimik]

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
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


Done
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

 

[ChrisRHS]

From what I recall, I found a way to do this by copying the /scripts folder from the cpanel server, to the remote mysql server, then re-run the setup.

 

[jimik]

Thank Chris. That did the trick.

Much appreciated.