Reset the Gateway Database User Password

Products

• CA API Gateway
• API SECURITY

Issue/Introduction

How do you update the password for the "gateway" user to connect to internal MySQL DB of API Gateway?

Environment

API GATEWAY 9.3

Resolution

a) Access Gateway from the ssg config menu:

select 3) Login as Privileged user 

b) Access MySQL console

c) Execute the queries below: 

alter user 'gateway'@'%' identified by 'new_password';

alter user 'gateway'@'localhost' identified by 'new_password';

flush privileges;

d) Access Gateway from the ssg config menu:

select 2) Display CA API Gateway configuration menu

select 3) Configure the CA API Gateway

select 1) Database Connection

e) Enter the correct information including the new gateway 

user's password

f) Restart the ssg service