There was a connection error when attempting to connect to the database "ssg" using the username "gateway". Perhaps the password is wrong. Either the username and/or password is incorrect, or the database "ssg" does not exist.

Products

• CA API Gateway

Issue/Introduction

After importing the database, the database upgrade is failing with the following message:

Gateway Database Upgrader.
Enter 'quit' to exit at any time.

Database upgrade is required.
 Software version : 11.0.00
 Database version : 10.1.00
 
Perform upgrade? [No]: Yes

Enter Administrative Database Username [root]: 
Enter Administrative Database Password: 
Performing database upgrade:
  There was a connection error when attempting to connect to the database "ssg" using the username "gateway". Perhaps the password is wrong. Either the username and/or password is incorrect, or the database "ssg" does not exist.
Press [Enter] to continue

It's been confirmed that the root and gateway user passwords were updated and match the same passwords used in the source environment. 

Environment

All supported versions of the gateway

Resolution

The password for the 'gateway'@'localhost' user needed to be updated.

SQL Command: alter user 'gateway'@'localhost' identified by 'UPDATED_PASSWORD';