Ed, > That would work but is there no way to completely remove their record?
With REVOKE, you can partially or totally revoke privileges from users. What you can't do with REVOKE (in MySQL) is to erase a user completely. For this, you will have to DELETE FROM mysql.user WHERE User = 'user2bremoved'. You can even use this as an alternative way to remove users. You need two statements for this, just in case ... DELETE FROM mysql.user WHERE User = 'user2bremoved'; DELETE FROM mysql.db WHERE User = 'user2bremoved'; Opposed to GRANT and REVOKE DELETE will not cause the server to notice the privilege changes. You need another statement for this: FLUSH PRIVILEGES; This will force the server to reload the grant tables, and thus, the privileges. Details: http://www.mysql.com/doc/en/User_Account_Management.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Michael T. Babcock" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 7:10 PM Subject: Re: Removing users > > That would work but is there no way to completely remove their record? > > Ed > > > On Mon, 13 Jan 2003, Michael T. Babcock wrote: > > > [EMAIL PROTECTED] wrote: > > > > > I've read the manual concerning REVOKE commands but how would I > > >completely remove a user inside MySQL? I can't imagine that it's as easy > > >as removing them from the user table. > > > > > > > > > > If you remove them (or blank their password) in the user table, they'll > > have no way of logging in, since MySQL won't be able to authenticate them. > > > > -- > > Michael T. Babcock > > C.T.O., FibreSpeed Ltd. > > http://www.fibrespeed.net/~mbabcock > > > > > > > --------------------------------------------------------------------- > 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
