Re: MySQL 4.0.13 GRANT syntax

2003-06-25 Thread Fred van Engen
On Wed, Jun 25, 2003 at 10:09:58AM -0400, Adam Lawrence wrote: I am attempting to modify the GRANT table using the syntax specified in the MySQL 4.0.13 documentation, and am getting error messages claiming the syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used mysqlc

RE: MySQL 4.0.13 GRANT syntax

2003-06-25 Thread Mike Hillyer
Does enclosing the username and host in single quotes help? I.E. GRANT SELECT ON *.* TO 'update'@'localhost' IDENTIFIED BY 'update'; Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Adam Lawrence [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 8:10 AM To:

RE: MySQL 4.0.13 GRANT syntax

2003-06-25 Thread csebe
update is a reserved word in MySQL. Choose another username. Lian Sebe Freelance Analyst-Programmer www.programEz.net -Original Message- From: Adam Lawrence [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 5:10 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0.13 GRANT syntax I