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

Document ID : KB000034286
Last Modified Date : 14/02/2018
Show Technical Document Details
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