* Franz Edler > I have a perhaps simple problem, but it's a problem for me: > > I have made the following GRANT statement: > mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED]; > Query OK, 0 rows affected (0.01 sec) > > But when I want to REVOKE the GRANT I get the following syntax error: > > mysql> REVOKE ALL ON ser.* TO [EMAIL PROTECTED]; > 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 > 'TO [EMAIL PROTECTED]' at line 1 > > What is wrong in the syntax? I only changed GRANT with REVOKE. > I am using mySQL version 4.0.15.
It's "GRANT ... TO ..." and "REVOKE ... FROM ...". <URL: http://www.mysql.com/doc/en/GRANT.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]