Getting Access denied for user 'gateway'@'%' to database 'ssg10_testUpgrade'
Gateway Database Upgrader.
Enter 'quit' to exit at any time.
Enter database host [localhost]: lxcamysqldev01.pfsfhq.com
Enter database port [3306]:
Enter database name [ssg]: ssg10
Enter database username [gateway]:
Enter database password:
Database upgrade is required.
Software version : 10.1.00
Database version : 9.4.00
Perform upgrade? [No]: yes
Enter Administrative Database Username [root]: gateway
Enter Administrative Database Password:
Performing database upgrade:
Testing the upgrade on a test database ...
Creating test database "ssg10_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 'ssg10_testUpgrade'
No changes have been made to the database. Please correct the problem and try again.
Press [Enter] to continue
Root cause the documentation are missing key steps when the SSG database is external and named different (Permission to create and test the upgrade)
Release : 10.1
Component :
Link from the 9.4 docs for scenario 2
Resolution
Modify Permissions on the Database Host
Next, perform these permissions grants on the master database host:
Run the following MySQL commands to modify the permissions for the Administrative Database User (ADU);