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.
Why is it weird? What if you wanted to include a '@' character in your username? '[EMAIL PROTECTED]'-style quoting wouldn't allow that. :-)
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
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]