hi all,

Does drop database command removes all the users permissions related with
that databases or those user permissions has to be revoke manually.

Regards,
Krishna

Hi,

> Does drop database command removes all the users permissions related with
> that databases or those user permissions has to be revoke manually.

DROP DATABASE does not remove the privileges. You have to
remove that separately.


Best regards,
Aleksandar

Hi Bradaric,

On my system innodb storage engine is used. If i drop all the databases even
then also i cannot reclaim the free space. For that i need to remove the
ibdata , ib_logfile0, ib_logfile1 and other databases folder. then restart
mysql.

What will be the impact if i don't remove the users privileges. Does mysql
will restart successfully or not. OR should i remove the users privileges
before dropping the database.

Please guide me.
Regards,
krishna



On 8/17/07, Aleksandar Bradaric <bradaric@gmail.com> wrote:
>
> Hi,
>
> > Does drop database command removes all the users permissions related
> with
> > that databases or those user permissions has to be revoke manually.
>
> DROP DATABASE does not remove the privileges. You have to
> remove that separately.
>
>
> Best regards,
> Aleksandar
>
>

Hi,

> What will be the impact if i don't remove the users privileges. Does mysql
> will restart successfully or not. OR should i remove the users privileges
> before dropping the database.

It will restart sucessfully. The only impact I can see is
that next time a database with the same name is created, the
not-removed users will have access to it.


Best regards,
Aleksandar