Bug #31713 too many hosts in mysql.user for user root
Submitted: 19 Oct 2007 11:16 Modified: 20 Dec 2007 17:41
Reporter: Susanne Ebrecht Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Packaging Severity:S2 (Serious)
Version:5.1.22 OS:Windows
Assigned to: Kent Boortz CPU Architecture:Any
Tags: unscheduled

[19 Oct 2007 11:16] Susanne Ebrecht 
Description:
After downloading (from the webpage) and installing MySQL 5.1.22, I have had very intersting hosts for the user root in mysql.user. 

How to repeat:
download the community server 5.1.22 for windows (Windows ZIP/Setup.EXE (x86)).
install it.
Open the CLI out of the DOS Shell.

mysql> select user,host from mysql.user;

look to the user root and the host

Suggested fix:
Just drop the user before build.
[19 Oct 2007 11:34] MySQL Verification Team 
Thank you for the bug report.

 max_user_connections: 0
*************************** 2. row ***************************
                 Host: production.mysql.com
                 User: root
             Password:

Changing category to packing.
[20 Dec 2007 17:41] Timothy Smith 
Duplicate of Bug #32219