Put quotes around the hostname:
grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net'
identified by 'X';
Peter
On Thu, 7 Feb 2002, 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.
>
--
GPG ID D40940EC
FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC
---------------------------------------------------------------------
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
