Re: domain name bug

2002-02-13 Thread Craig Vincent
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, Insert,

domain name bug

2002-02-12 Thread Paul Faber
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

Re: domain name bug

2002-02-12 Thread Peter Banik
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,

domain name bug

2002-02-07 Thread Paul Faber
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

Re: domain name bug

2002-02-07 Thread Peter Banik
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,

Re: domain name bug

2002-02-07 Thread Doug Thompson
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