mysql revoke syntax not working.

[duckxtales]

Hi,

I am trying to revoke a user i made to the database "mysql".

I typed this command and it doesnt seem to work:

revoke all on mysql.vbox_vbox, grant option from 'pat'@'localhost';

Grants for pat@localhost
GRANT USAGE ON *.* TO 'pat'@'localhost' IDENTIFIED BY PASSWORD
GRANT ALL PRIVILEGES ON `vbox_vbox`.* TO 'pat'@'localhost' GRANT ALL PRIVILEGES ON `mysql`.`vbox_vbox` TO 'pat'@'localhost'

thanks

[eelixduppy]

Are you getting any errors from the query?

Maybe you'll have better luck at the documentation: Revoke Syntax [dev.mysql.com]. Also take a look at Account Management Statements [dev.mysql.com].

For future reference, you might get a better response if you ask your questions in the Database forum [webmasterworld.com] ;)

Good luck!

[coopster]

Also don't forget to FLUSH PRIVILEGES after making changes.