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

Reply via email to