Bug #73688 False positive for "Server Has No Locally Authenticated Root User "
Submitted: 22 Aug 2014 12:02 Modified: 6 Feb 2015 11:31
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S3 (Non-critical)
Version:3.0.13, 3.0.19 OS:Any
Assigned to: CPU Architecture:Any

[22 Aug 2014 12:02] Daniël van Eeden
Description:
This advisor uses the data item "mysql:local_auth_root:count".

The server does have a locally authenticated root user

mysql> select user,host,plugin from mysql.user where user='root';
+------+-----------+--------+
| user | host      | plugin |
+------+-----------+--------+
| root | %         |        |
| root | 127.0.0.1 |        |
| root | ::1       |        |
+------+-----------+--------+
3 rows in set (0.00 sec)

I would have expected mysql_native_password in the plugin field, but it's empty. The first char of the password field is '*', so it is a native password.

The mysql server runs 5.6.

How to repeat:
Schedule plugin on a server without root@localhost, but with root@::1 and root@127.0.0.1.

Suggested fix:
Improve data collection item on the agent.
[6 Feb 2015 9:42] MySQL Verification Team
Hello Daniel,

Thank you for the bug report.

Thanks,
Umesh
[6 Feb 2015 9:45] MySQL Verification Team
Screenshot..

Attachment: mysql_native_password_FA.png (image/png, text), 123.61 KiB.

[6 Feb 2015 11:31] Daniël van Eeden
It looks like this just checks for root@localhost.