Broadcom API Gateway - after installing June's 2022 Monthly Platform Patch, got Access Denied error when locally log into MySQL console as 'root' user

Products

• CA API Gateway

Issue/Introduction

After applied June's 2022 MPP (Layer7_API_PlatformUpdate_64bit_v10.X-CentOS-2022-06-26.L7P), MySQL console "root" local authentication fails even if the password is correct and localhost grants are correctly set.

Environment

Gateway 10.x Appliance

Cause

June's MPP ugrades MySQL to version 8.0.29. There seems to be a bug or undocumented change in MySQL.

When the -p option (without adding the password) is used in the login syntax and ENTER is pressed, MySQL rather than ask for a password, attempts to read credentials stored in /root/.my.cnf file. If the stored password for root user was changed, it fails the authentication. This shouldn't happen, and the expected behaviour is that MySQL should prompt to type a password if/when omitted from the syntax. 

Resolution

The following workaround can be used to bypass the problem:

Option 1. Enter the password within the syntax:

# mysql -u root -p<password_here>  (NOTE: no space between -p and password)

Option 2. If you desire for the password to be requested at the prompt, rename the .my.cnf file to something else

# mv /root/.my.cnf /root/.my.cnf.backup