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 with root access. > > mysql> USE mysql; > Database changed > mysql> GRANT SELECT ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'update'; > ERROR 1064: You have an error in your SQL syntax. Check the manual that > corresponds to your MySQL server version for the right syntax to use near > '[EMAIL PROTECTED] IDENTIFIED BY 'update'' at line 1 > mysql> >
Try [EMAIL PROTECTED] instead. UPDATE is a reserved word in SQL. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]