From: Ari Davidow [mailto:[EMAIL PROTECTED] > I seem to have run into a problem with a host name that > incorporates a hyphen: > > mysql> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY "foo"; > ERROR 1064: You have an error in your SQL syntax near > '-dev.foo.com IDENTIFIED BY "foo"' at line 1 > mysql> GRANT ALL ON *.* TO "[EMAIL PROTECTED]" IDENTIFIED > BY "foo"; > ERROR 1145: The host or user argument to GRANT is too long > > I must be missing something very obvious--how to incorporate > a hostname with a hyphen, for instance. Can someone help?
The syntax is a bit weird for GRANT statements; either side of [EMAIL PROTECTED] are two separate args to be stored in two separate columns. This should work... GRANT ALL ON *.* TO 'me'@'mysite-dev.foo.com' IDENTIFIED BY 'foo'; -- Mike Johnson Web Developer/Systems Asst. Smarter Living, Inc. phone (617) 497-2500 x226 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]