Web Hosting Talk







View Full Version : cPanel/WHM setting up remote mysql connection


BurakUeda
01-08-2007, 10:10 AM
I get this error:
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 '-server102.net IDENTIFIED BY 'CloakHPu' WITH GRANT OPTION' at line 1

Server name is "server1.kanmonline-server102.net". Is hyphen causing the problem?
If so, is there any solution?
Any ideas would be appreciated

HostingTrade
01-09-2007, 10:51 PM
Hi.

Did you try to use IP of the server1.kanmonline-server102.net host instead?

ServerNinja
01-09-2007, 11:38 PM
Please try the following format:

mysql> grant all privileges on testingg.* to testin@'server1.kanmonline-server102.net (testin@%27server1.kanmonline-server102.net)' identified by 'tetsd';

The hyphen will create the problem unless it is not specified within quotes. ;)