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)
• Status: Verified
• Category: MySQL Enterprise Monitor: Advisors/Rules
• Severity: S3 (Non-critical)
• Version: 3.0.13, 3.0.19
• OS: Any
• 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.