The GRANT OPTION privilege exists in different contexts ( mysql.user mysql.db ) for the purpose of governing the ability of a privileged user to manipulate the privileges of other users. The GRANT OPTION privilege allows a principal to grant other principals additional privileges. This may be used by an attacker to compromise MySQL. NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.
Solution
Perform the following steps to remediate this setting: - Enumerate the non-administrative users found in the result sets of the audit procedure - For each user, issue the following SQL statement (replace <user> with the non-administrative user): REVOKE GRANT OPTION ON *.* FROM '<user>';