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