Paul, Thank you. That did it. You are correct I needed to DELETE.
Paul DuBois wrote: > > At 16:26 -0700 9/10/02, Daniel Curry wrote: > > I am unable to find the specific DROP command to remove only test@%, > >test\_%@%, > >snort@localhost, and snort@%. > > I think you want DELETE, not DROP. > > DELETE FROM db WHERE Db='test' AND Host='%'; > DELETE FROM db WHERE Db='test\_' AND Host='%'; > DELETE FROM db WHERE Db='snort' AND Host='localhost'; > DELETE FROM db WHERE Db='snort' AND Host='%'; > > > > > I am trying to clean up my db information. > > > >Thank you. > > > > > >mysql> select * from db; > >>+-----------+----------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ > >| Host | Db | User | Select_priv | Insert_priv | > >Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | > >References_priv | Index_priv | Alter_priv | > >>+-----------+----------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ > >| % | test | | Y | Y | > >Y | Y | Y | Y | N | > >Y | Y | Y | > >| % | test\_% | | Y | Y | > >Y | Y | Y | Y | N | > >Y | Y | Y | > >| localhost | snort | snort | Y | Y | > >Y | Y | Y | N | N | > >N | N | N | > >| % | snort | snort | Y | Y | > >Y | Y | Y | N | N | > >N | N | N | > >| localhost | snort_db | snort | Y | Y | > >Y | Y | N | N | N | > >N | N | N | > >| % | snort_db | snort | Y | Y | > >Y | Y | N | N | N | > >N | N | N | > >>+-----------+----------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ > >6 rows in set (0.00 sec) > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
