Do Not Reuse Usernames

低等級 1人工審核mysql

說明

Database user accounts should not be reused for multiple applications or users.

檢查方式

稽核方法: 人工審核

此項建議無法自動檢查。當您傳入 --include-manual 時，掃描結果會列出此項目並附帶這些說明。

List accounts: SELECT host, user, plugin FROM mysql.user WHERE user NOT IN ('mysql.infoschema','mysql.session','mysql.sys'); Each account must belong to exactly one system account, person or application; shared or reused usernames are a fail.

修補方式

修補方法: 操作指南或基礎設施修補檔

Create a separate account per person, application and system account, migrate their grants, and drop the shared accounts.

屬性

作業系統: 不限
標籤: mysqldatabaseauthenticationmanual
參考資料: CIS Oracle MySQL Community Server 8.4 Benchmark v1.1.0 - 2.5 Do Not Reuse Usernames