delete from mysql.user where mysql.user.user='somebody';
or
use mysql;
delete from user where user='somebody';
for a list of users,
delete from user where user in ('somebody', 'anotherone', 'yetanother');
Jim Michaels
----- Original Message -----
From: "Jerad Hampton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 10:18 AM
Subject: Deleting users
> Hello,
>
> I'm just learning mysql and have found how to add users but I need
> to delete some and can't find out how to do it.
>
> Can some one tell me how to do this.
>
> Thanks
> Jerad Hampton
> Network Administrator
> The King's University College
>
> ---------------------------------------------------------------------
> 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
