System Health Tests (Ping URI Test) returns access denied for mysql data

Products

• CA API Gateway

Issue/Introduction

We are upgrading Layer7 API Gateways 9.1 to 10.0 .
The ping URI response returns extended system information but we obtain an error 1045 for MySQL status and MySQL slave status.

However, the user account has the administrator role.

 

Environment

Release : 10.0

Component :

Resolution

If the password for the root user is changed the  .my.cnf file needs to be updated with the new password.

The .my.cnf file for root user still contains  the old password .

Update the /root/.my.cnf  with the new password .

NOTE: If your new password has special characters # or $ you need to encapsulate the password in 'some#pa$$W0rd' otherwise it will continue to have issues.