At 2:17 PM -0400 6/1/01, Peter H. Burris wrote:
>I know that when it comes to deleting users from the user table, I could
>revoke all privileges and use an SQL 'delete from' command, but I wonder
>if there's an easier script/method for dropping a user? I've been combing
>the manual for a couple days and while I can create users and grant/revoke
>privileges, simply deleting them has eluded me.
That's indeed how you do it. REVOKE doesn't remove the account record
from the user table, so you must DELETE it explicitly to remove not
just the account's privileges, but the account itself as well.
>
>--
>***+++++++++++++++++++++++++++++++++++++++++++++++++++++++++***
>*** [] ***
>*** Peter H. Burris, [] [EMAIL PROTECTED] ***
>*** Unix System Admin [] phone: 301.614.5110 ***
>*** CODE 922, Bldg 33 [] pager: 301.647.2752 ***
>*** [] ***
>***+++++++++++++++++++++++++++++++++++++++++++++++++++++++++***
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
