We're installing the mysql database for an AMI Gateway 10.1. The mysql is a 8.0.23 on AWS RDS.
The create database tool (with ssgconfig) failed with this error :
Error creating database when saving configuration 'Cannot create database: 'Access denied; you need (at least one of) the RELOAD privilege(s) for this operation' [code:42,000, UNKNOWNDB_FAILURE]'
However the Administrative Database Username owns the privileges.
Try to run the mysql command FLUSH PRIVILEGES using the Administrative Database account used in the gateway config
Does this work ?
mysql> FLUSH PRIVILEGES;
ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
Ask your AWS MySQL DBA to add the FLUSH_PRIVILIEGES privileges to this account .