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

Products

• DX Infrastructure Management
• 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: