What MySQL user permissions are necessary for the mysql probe to function properly?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

What MySQL user permissions are necessary for mysql probe to function properly?

 

Environment

• This is general information applicable to most UIM versions.

Resolution

The MySQL user needs the following privileges:

1. MySQL user must have the Super and Replication Client global attributes

2. The mysql user configured in probe must have access to the information_schema database.

3. The mysql user configured in probe must have access to the following queries on the mysql server.

• SHOW GLOBAL STATUS
• SHOW SLAVE STATUS
• SHOW VARIABLES
• SHOW DATABASES

 

SELECT TABLE_NAME, AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND MAX_DATA_LENGTH > 0 ORDER BY TABLE_SCHEMA ASC

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/mysql-mysql-server-monitoring/mysql-mysql-server-monitoring-release-notes.html