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