> 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
Try
grant Select, Inser
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.2
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 PROTEC
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)
>
>th
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.2
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 PROTEC
