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

Article Id: 34286
Status: Published
Updated On: 14-02-2018 08:19
Legacy Id: TEC000001800
Products:
CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) , NIMSOFT PROBES
Issue/Introduction:

Question: 

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

 

Environment:  

This is general information applicable to most UIM versions

 

Answer: 

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:

MySQL Probe Information

Environment:

Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component: