Unable To Connect To Mysql Interface

Products

• CA API Gateway

Issue/Introduction

After applying the Layer7_API_PlatformUpdate_64bit_v10.X-CentOS-2022-05-23.L7P monthly platform patch we are no longer able to connect to the mysql interface by executing the following command:

mysql -h HostName -u UserName -p

 

We don't get prompted to enter the password and will immediately receive the following error:

ERROR 1045 (28000): Access denied for user 'UserName'@'HostName' (using password: YES)

Environment

CA API Gateway 10.x

Cause

The version of mysql was upgraded to 8.0.29 within the May 2022 MPP which is resulting in the situation being seen.

Resolution

Specify the password directly within the command and we will then connect successfully to the mysql interface.

mysql -h HostName -u UserName -p MyPassword