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 <[EMAIL PROTECTED]> 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 > >
