In upgrade API Gateway to 9.2.
Error occurred in the following.
"Upgrade Gateways on RHEL/CentOS/SUSE Linux" -> "If Using the MySQL Database" -> 12. Upgrade the CA API Gateway database on one node. Tip: To do this, use option 1 ("Upgrade the CA API Gateway database") on the Gateway Main Menu (Software).
/********************************
Gateway Database Upgrader.
Enter 'quit' to exit at any time.
Database upgrade is required.
Software version : 9.2.00
Database version : 9.1.00
Perform upgrade? [No]: Yes
Enter Administrative Database Username [root]:
Enter Administrative Database Password:
Performing database upgrade:
Testing the upgrade on a test database ...
Creating test database "ssg_testUpgrade" (without audits).
Database creation may take a few minutes.
The database was not upgraded due to the following reasons:
Access denied for user 'gateway'@'%' to database 'ssg_testUpgrade'
No changes have been made to the database. Please correct the problem and try again.
Press [Enter] to continue
/********************************
Also, when Database is remote MySQL, the problem occurs.
This reason is remote DB.
So, If you use remote DB, gateway account can not create ssg_testUpgrade.
Run the following sql statement on the target MySQL:
GRANT ALL ON *.* TO 'gateway'@'%';
FLUSH PRIVILEGES;
Restart MySQL and retry the DB upgrade.