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)
CA API Gateway 10.x
The version of mysql was upgraded to 8.0.29 within the May 2022 MPP which is resulting in the situation being seen.
Specify the password directly within the command and we will then connect successfully to the mysql interface.
mysql -h HostName -u UserName -p MyPassword