How to change parameter partial_revokes

Hi Max-Max

If you are unable to locate the parameter within the parameter group, that means that parameter is currently not modifiable/supported within RDS.
Not all parameters available in MySQL 8.0 are modifiable for RDS MySQL.To determine the supported parameters for your DB engine, you can view the parameters in the DB parameter group used by the DB instance. For more information, see [1].

You can easily use the CLI command below to view the parameters for the parameter group, use grep to filter for the parameter you’re looking for:

aws rds describe-db-parameters --db-parameter-group-name default.mysql8.0 | grep partial_revokes

To learn more about the CLI and grep commands see [2] & [3]

Executing the statement SHOW VARIABLES would indeed show partial_revokes in the results list, however RDS being a managed service, there is limited access to OS level changes and SUPER privileges are restricted. Running the "SET PERSIST partial_revokes = ON;" on the database itself would give an access denied error.

I hope this helps

References:

[1] Viewing parameter values for a DB parameter group
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html#USER_WorkingWithParamGroups.Viewing

[2]CLI command
https://docs.aws.amazon.com/cli/latest/reference/rds/

[3] How to use grep
https://www.ibm.com/docs/zh/aix/7.1?topic=g-grep-command