Ensure No Anonymous Accounts Exist

高级别 1自动化mysql

说明

Anonymous accounts are users with empty usernames (''). Anonymous accounts have no passwords, so anyone can use them to connect to the MySQL server. Runs mysql -NBe with the client defaults: put an administrative account in ~/.my.cnf (mode 0600) or a mysql_config_editor login path, not MYSQL_PWD (see 1.4/1.6).

检查方式

审计方法: SQL 查询

sql_query

out=$(mysql -NBe "SELECT COUNT(*) FROM mysql.user WHERE user = ''" 2>/dev/null) || exit 1; printf '%s\n' "$out"

预期输出: 0

修复方式

修复方法: 操作指南或基础设施补丁

DROP USER ''@'<host>'; for each anonymous account (or run mysql_secure_installation).

属性

操作系统: 任意
标签: mysqldatabaseauthentication
参考: CIS Oracle MySQL Community Server 8.4 Benchmark v1.1.0 - 7.7 Ensure No Anonymous Accounts Exist

检查本机

请在您有权审计的机器上运行此命令。扫描为只读操作。

shell

tmaegis scan --target mysql