search cancel

API gateway Installation -> RELOAD mysql privilege error

book

Article ID: 229615

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

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.

Environment

Release :

Component :

Resolution

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 .