The following just worked in a test case for me: ...user@"test-test.com"...
On Thu, 7 Feb 2002 06:29:59 -0500, Paul Faber wrote: >Not sure if thius is supposed to go here but my version of MySQL > >mysql> status; >-------------- >mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686) > >the GRANT command errors out when the domain name has a '-' dash in it. > > > >mysql> grant Select, Insert, Update, Delete on X.* to [EMAIL PROTECTED] >identified by 'X'; >ERROR 1064: You have an error in your SQL syntax near '-tech.net identified >by 'X'' at line 1 > > >escaping the - makes things worse. > >Paul Farber >Farber Technology > >570-628-5303 > >www.f-tech.net > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php