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.

Please Help Im Not A Twat (Remote SQL)

Discussion in 'Database Discussions' started by Bennylovster, Dec 6, 2006.

  1. Bennylovster

    Bennylovster Member

    Joined:
    Aug 17, 2006
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Please help i have tryed everything i need a response ASAP im trying to use one of my server as a remote SQL server now this is the error i get

    Using Remote mySQL Server
    Copying Mysql Script.....0%.. ..100%.. ...Done
    Running Mysql Script...

    Using 66.79.167.91 as the access ip
    Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)....@69.72.164.155......connected......receiving......Done
    Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)....@69.72.164.155......connected......receiving...30%...60%...90%...100%......Done
    ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-hosting.com IDENTIFIED BY 'aM5cE8S6' WITH GRANT OPTION' at line 1

    I have not seen anyone else with this problem but i really need to sort it fast
     
  2. Nhojohl

    Nhojohl Well-Known Member

    Joined:
    Nov 28, 2006
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    16
    It looks as if there is a conflict with a username, a username ending in '-hosting.com'. Pretty sure its an invalid mysql user...

    I'd suggest re-naming it and trying again...

    Hope I helped:eek:
     
  3. Bennylovster

    Bennylovster Member

    Joined:
    Aug 17, 2006
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    There is no users that come under the name of -hosting i have domains on there called utrust-hosting.com i really need to fix this i have some sites that use's alot on MySql and it would make the server run alot better if the SQL server was remote and running on another server but with that error it does not let me do it i upgraded to MySql 5.0 and i seem to have had loads of problems from there
     
Loading...

Share This Page