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,
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
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,
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
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,
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