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 <[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
---------------------------------------------------------------------
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
