The MySQL user the Database Agent uses to monitor the MySQL database must have "SELECT", "PROCESS", and "SHOW DATABASES" privileges on all databases.

The user must also have the "REPLICATION CLIENT" privilege to collect these metrics:

• Slave_io_running
• Slave_sql_running
• Seconds_behind_master
• SQL_Delay

If you do not have a suitable existing user, you can use the command below to create a new user.

CREATE USER 'DBMon_Agent_User'@'host' identified by 'password';
GRANT SELECT,PROCESS,SHOW DATABASES on *.* to 'DBMon_Agent_User'@'host' identified by 'password';
GRANT REPLICATION CLIENT ON *.* to 'DBMon_Agent_User'@'host';
FLUSH privileges;

Substitute DBMon_Agent_User with the username under which you run the Database Visibility Agent. Substitute host with the hostname or IP address of the machine running the Splunk AppDynamics Database Agent, and substitute password with a secure password.

Set the max_allowed_packet parameter to 1073741824 on the server.