On Thu, Nov 18, 2004 at 01:27:09AM +0000, MJ Ray wrote:
On 2004-11-17 21:19:23 +0000 Chris Green chris@areti.co.uk wrote:
How do I delete a mysql user?
Either "drop user ..." or "delete from mysql.user where ..." depending on version.
I couldn't find "drop user ..." in my O'Reilly mysql book, hence the question.
Is removing the entry from the mysql.user table guaranteed to remove the user, there seem to be 'User' columns in quite a few of the other mysql database tables.
... and how do I stop a mysql user requiring a password?
Blank the password column in mysql.user, perhaps. Ask yourself: are you sure you want to do that?
Yes, it's a SoHo system behind a NAT (plus more) firewall, no access to any users except members of the family and no information of any use to anyone in the database anyway.
Remember to "flush privileges;" after editing users.
Aha, now that I have been forgetting and it may well explain the strange behaviour I have been seeing of course.