When you install the OMS agent for Linux, the agent looks for an instance of MySQL server or MariaDB server, and, if detected, the mysql-cimprov package with the performance monitoring provider for MySQL server will be automatically installed. The provider connects to the detected MySQL server and exposes performance data for MySQL/MariaDB. The MySQL OMI provider makes use of a preconfigured MySQL user to access the MySQL server. The user will need access to the following queries:
SHOW GLOBAL STATUS;SHOW GLOBAL VARIABLES;
The MySQL user will also require SELECT access to the following tables:
- MySQL
- Information_schema
- Run the following commands to define a user account for the MySQL server on localhost ...