Having problems with REVOKE

I am having problems with the Revoke statement. I add a database and give the user privileges with this Grant statement GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER ON $userdatabase.* TO '$newuser'@'localhost' IDENTIFIED BY '$newuserpass But when I delete the database I what to take all of the privileges away from the user I have tried REVOKE SELECT,INSERT,UPDATE,DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER on $userdatabase.* from $newuser I get this error with this one 1141: There is no such grant defined for user 'test3456' on host '%' and I have tried REVOKE SELECT,INSERT,UPDATE,DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER ON $userdatabase.* TO '$newuser'@'localhost' IDENTIFIED BY '$newuserpass The manual does not go into REVOKE as much as it does for GRANT so what am I missing hear. also I realize that the revoke statement does not remove the info from the db table or the usr table. How do I go about that without debiting a user for a different database. On the db table it is easy because I can do it were usr = $user and db = $db but in the usr table every host name is localhost and the password is encrypted is there a way to do somthing like were user =$username and password =$password(encrypted). Yes I could go there manually. and remove it but this is being done by a program in PHP that will remove the database revoke the privileges and reset all of the info in a customers information database Best regards, Richard mailto:rkurth@pacifier.com