Use the following procedures to enable monitoring.
Follow these steps to set up your MySQL server to allow Zenoss to read performance data from the system tables.
Connect to the MySQL database by using the MySQL client:
mysql -u root
Alternatively, if there is a MySQL root password:
mysql -u root -p
Create a user for Zenoss to use. The username "zenoss" is recommended.
mysql> CREATE USER zenoss IDENTIFIED BY '
zenossPassword
'; Query OK, 0 rows affected (0.00 sec)
Select Infrastructure from the navigation bar.
Click the device name in the device list.
The device overview page appears.
Select Configuration Properties from the left panel.
Edit the zMySqlRootPassword configuration property for the device or devices in Zenoss on which you want to monitor MySQL.
Click Save.
Expand Monitoring Templates, and then select Device from the left panel.
Select Bind Templates from the Action menu.
The Bind Templates dialog appears.
Add the MySQL template to the list of selected templates, and then click Submit.
The MySQL template is added to the list of monitoring templates.
Note
Pay particular attention to the MySQL Version 5+ setting in the data source. If you are monitoring pre-v5 installations of MySQL, then you must set this value to False. If you are monitoring pre-v5 and v5+ installations, then create two templates: one for MySQL installations earlier than v5 and another for those after.