> > I don't know how to remove users other than directly removing them from > > mysql.user table > > > > > This may be very obvious but being a new mysql admin user how do I do what > you say above, to delete the user from the user table. There doesn't > appear to be any examples of this in the docs.
=Isn't that curious - instructions to add new users, but not to remove - the Hotel California philosophy? =In addition to the obvious 7.35 GRANT and REVOKE Syntax, the manual offers chapter 6 The MySQL Access Privilege System - in particular 6.14 Adding New Users to MySQL which offers examples/compares GRANT with direct manipulation of the authority tables. Once understood, REVOKE-ing a user becomes straightforward (pity we don't have referential integrity to cope with all those tables though!) =dn --------------------------------------------------------------------- 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
