missing something obvious w/grant statement length?

[Ari Davidow]

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?

ari

Ari Davidow
[EMAIL PROTECTED]
http://www.ivritype.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]