RDS recently upgraded our mysql db to 8.0.40 from 8.0.35, post that our vault service is unable to create users on database, getting access denied, can any one help us on this if you faced similar issue ?
Error:
vault read mysql-shard-db/creds/ro
Error reading mysql-shard-db/creds/ro: Error making API request.
URL: GET https://127.0.0.1:8200/v1/mysql-shard-db/creds/ro
Code: 500. Errors:
-
1 error occurred:
-
Error 1227: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
user has this permissions initially
SHOW GRANTS FOR ‘vault-shard’;
±----------------------------------------------------------------------+
| Grants for vault-shard@% |
±----------------------------------------------------------------------+
| GRANT USAGE ON . TO vault-shard@% |
| GRANT ALL PRIVILEGES ON %.* TO vault-shard@% WITH GRANT OPTION |
±----------------------------------------------------------------------+
Vault version: v0.8.3