MySQL 3.23.36 (yeah, I know it's getting old...): What permission do I need to run the following query:
REVOKE ALL ON mydb.* FROM 'sdaf'@'%'; I get an error 1044: "Access denied for user: 'Admin@<IP address>' to database 'mydb'" My user has GRANT permission on mydb (database) and GRANT permission on all tables except two (with only SELECT permission). I tried removing all table based permissions, but that didn't help. I assigned GRANT permissions to all tables in the database, but that didn't help either. Assigning SELECT, UPDATE permissions on the mysql database didn't help either? TIA, Tore.
