Guys i need a simple help from you guys. There's a scenerio that i m sure is very common in mysql and i know most of you can answer that but i m new to mysql so need some basic polish.
so my scenerio is that for example i have 100 database.
i create a new database (sample)
now i create new user (user1)
now i want to give grant access to user1 on all databases except SAMPLE..
what i should do ??
NOTE: What i did was give
Grant all privileges on *.* to 'user1'@'localhost'; revoke all privileges on sample.* from 'user'@'localhost';
now you all know that what error mysql gave when revoking...its say that no privileges define to revoke etc...
how you guys do it??