[KLUG Members] mysql's grant command

[Jamie McCarthy]

agencies_ad1 at sancharnet.in (komal) writes:

> It is possible to force MySQL's grant and revoke command to
> check the existence of database and table. For example, I have
> no pet database and if I execute grant select on pet.* to
> komal at binu, MySQL does not complain at all. Is this acceptable
> behavior or I am missing something?

That's how it's supposed to work.  Your permissions for a database
have to stick around if you DROP and re-CREATE that database.  So
the permissions exist regardless of whether the database exists at
any given point in time.

http://dev.mysql.com/doc/mysql/en/GRANT.html
-- 
  Jamie McCarthy
 http://mccarthy.vg/
  jamie at mccarthy.vg