Issue upgrading Gateway database to 9.3

Document ID : KB000074992
Last Modified Date : 29/03/2018
Show Technical Document Details
Introduction:
When trying to upgrade a software appliance 9.2 CR7 to 9.3 and getting to the database upgrade we might get "Unable to determine database version (incorrect credentials?), cannot upgrade." when trying to upgrade the database even though our password has not changed.

 
Question:
Getting "Unable to determine database version (incorrect credentials?), cannot upgrade." when trying to upgrade the database even though our password has not changed.
Environment:
Red Hat 6.9, Gateway 9.2 CR7 software edition.
Answer:
Env: Gateway 9.2 CR7 software edition.
Installing the MYSQL 5.7 Server RPM was not enough.
Running the below command:
mysql_upgrade -u root -p<password>
and then restarting MYSQL resolved the problem.