Please Help Im Not A Twat (Remote SQL)

Bennylovster

Member
Aug 17, 2006
11
0
151
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)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (0)[email protected]%...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
 

Nhojohl

Well-Known Member
Nov 28, 2006
100
0
166
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
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:
 

Bennylovster

Member
Aug 17, 2006
11
0
151
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