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.

Remote MySQL problem

Discussion in 'General Discussion' started by jimik, Apr 15, 2009.

  1. jimik

    jimik Registered

    Joined:
    Sep 17, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. ChrisRHS

    ChrisRHS Well-Known Member

    Joined:
    Jul 12, 2006
    Messages:
    292
    Likes Received:
    5
    Trophy Points:
    18
    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.
     
  3. jimik

    jimik Registered

    Joined:
    Sep 17, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Thank Chris. That did the trick.

    Much appreciated.
     
Loading...

Share This Page