MySQL

Open the interface for the database you want to monitor and enter one of the following commands:

For Normal Usage:

GRANT REPLICATION CLIENT on *.* TO
'<<username>>'@'<<host>>' IDENTIFIED BY
'<<password>>';

If you're having permission issues with the above command, try this one instead:

GRANT ALL PRIVILEGES ON * . * TO
'<<username>>'@'<<host>>';

For Innodb Engine Status:

GRANT SUPER ON *.* TO
'<<username>>'@'<<host>>' IDENTIFIED BY
 '<<password>>';

For Innodb Engine Status on MySQL Versions 5.1.24 and greater:

GRANT PROCESS ON *.* TO
'<<username>>'@'<<host>>' IDENTIFIED BY
''<<password>>';

Navigate to the MySQLCollector.conf file.

The default location is /opt/netuitive-agent/conf/collectors/MySQLCollector.conf.

Change the enabled setting to True.

Change the hosts setting to the proper credentials:

Save the file, and restart the Linux Agent.