✘ Failed to execute: SELECT CONCAT(QUOTE(user), '@', QUOTE(host)) FROM mysql.user WHERE (password = '' OR password IS NULL) ...

[lewart3]

MySQL 8.0.45:

-------- Security Recommendations ------------------------------------------------------------------
ℹ  MySQL Community Server - GPL - 8.0.45
✔  No Role user detected
✔  There are no anonymous accounts for any database users
✘  Failed to execute: SELECT CONCAT(QUOTE(user), '@', QUOTE(host)) FROM mysql.user WHERE (password = '' OR password IS NULL)
    AND user != ''
    /*!50501 AND plugin NOT IN ('auth_socket', 'unix_socket', 'win_socket', 'auth_pam_compat') */
    /*!80000 AND account_locked = 'N' AND password_expired = 'N' */
✘  FAIL Execute SQL / return code: 256

[lewart3]

The security_recommendations logic for determining $PASS_COLUMN_NAME is very broken.

[jmrenouard]

Fixed: https://github.com/jmrenouard/MySQLTuner-perl/tree/v2.8.38