Bug #46022 Advisor rule suggests renaming root@localhost which raises 3 other alerts

• Submitted: 7 Jul 2009 21:51
• Modified: 9 Jul 2009 0:42
• Reporter: Matthew Montgomery
• Status: Duplicate
• Category: MySQL Enterprise Monitor: Advisors/Rules
• Severity: S3 (Non-critical)
• Version: 2.0.0.7071
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[7 Jul 2009 21:51] Matthew Montgomery

Description:
Rule "Server Includes A Root User Account   (v 1.3 *)" has Recommended Action "UPDATE user SET user = 'new_name' WHERE user = 'root'; FLUSH PRIVILEGES;"

Three other rules look for user !='root' with administrative grants.  Following the advice of the first alert will raise the following three.

Non-Authorized User Has DB, Table, Or Index Privileges On All Databases
Non-Authorized User Has GRANT Privileges On All Databases
Non-Authorized User Has Server Admin Privileges 

How to repeat:
n/a

Suggested fix:
Please avoid conflicting advisor recommendations.

[9 Jul 2009 0:43] MySQL Verification Team

Dup. of 46023