How to remove access from only one database(MySQL)
 

Hello,

I have given access for all databases to one user with the below command:

GRANT ALL PRIVILEGES ON *.* TO user@host IDENTIFIED BY 'passwd' WITH GRANT OPTION;

Now I want to remove privilege from that user from only one database. How can I do this?

Thanks,
Dipu

AFAIK you should revoke all privileges on *.*:
and then add manually the DBs that you want your user to have all privileges

Yes that I know but it's really irritating to do that when there are lots of databases on one server and I guess there is nothing like SCHEMA thing in MySQL