List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 10 2002 11:40pm
Subject:Re: need help on DROP.
View as plain text  
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

Thread
need help on DROP.Daniel Curry11 Sep
  • Re: need help on DROP.Paul DuBois11 Sep
  • Re: need help on DROP.Daniel Curry11 Sep
  • Re: need help on DROP.Gerald R. Jensen11 Sep