18 Nov
2004
18 Nov
'04
11:25 a.m.
On 2004-11-18 09:09:28 +0000 Chris Green chris@areti.co.uk wrote:
I couldn't find "drop user ..." in my O'Reilly mysql book, hence the question.
Maybe it documents an old version? It wouldn't be the first time an O'Reilly book was out of date...
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.
I think it removes the user - that is, they can't connect any more. For completeness, you should remove any lines mentioning them in mysql.db and other tables, else you may get unexpected results if you add a user with the same name.
--
MJR/slef My Opinion Only and not of any group I know
Creative copyleft computing - http://www.ttllp.co.uk/
Unsolicited attachments to the pipex address deleted
Will HLF fund tree-killings? http://www.thewalks.co.uk/