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 <mysql-thread119245@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
