Bug #20653 DML on data dictionary tables should not be documented anymore IMHO
Submitted: 23 Jun 2006 9:38 Modified: 30 Aug 2007 16:02
Reporter: Oli Sennhauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:5.0 OS:Any (n.a.)
Assigned to: MC Brown CPU Architecture:Any

[23 Jun 2006 9:38] Oli Sennhauser 
Description:
In the MySQL documentation still some manipulations on the data dictionary tables are documented like they where used in release 4.0/4.1.
IMHO this should not be anymore. Wer are in the 5.0/5.1 age now!

How to repeat:
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

DELETE FROM mysql.user WHERE User = '';

UPDATE mysql.user SET Password = PASSWORD('newpwd')
 WHERE User = '';

DELETE FROM mysql.user WHERE Host='localhost' AND User='';

Suggested fix:
drop user ''@'localhost';

set password for ''@'' = password(...);
[23 Jun 2006 9:41] Valeriy Kravchuk 
Thank you for a reasonable documentation request. I think, this 'tricks' should be moved to FAQ or HOWTOs, as answers to the related questions.
[30 Aug 2007 16:02] MC Brown 
I've removed the direct editing of the user tables from the documentation.