List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 13 2003 11:11pm
Subject:Re: Removing users
View as plain text  
At 23:40 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote:
>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'.

Better specify the Host value as well, in case you have multiple
accounts with the same User value.  :-)

>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 <hinz@stripped>
>   Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
>   Heesestr. 6, 12169 Berlin (Germany)
>   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

Thread
Removing usersed13 Jan
  • Re: Removing usersMichael T. Babcock13 Jan
    • Re: Removing usersed13 Jan
      • Re: Removing usersiConnect \(Berlin\) Stefan Hinz13 Jan
        • Re: Removing usersPaul DuBois14 Jan