Cacti monitoring MySQL

After downloading the CactiEZ on the Internet, I feel very good after one-click installation. However, MySQL monitoring is added, but MySQL is not a null value.

The net turned down found that some parameters have not changed to this. Make a record now

First enter the CactiEZ server to modify the following files

vim/var/www/html/scripts/ss_get_mysql_stats.php

1. Look for the following parameters, change the user name and password to the one you want as

$mysql _user = ' cacti ';

$mysql _pass = ' cacti ';

$mysql _port = 3306;

$mysql _ssl = FALSE; # Whether to the use of SSL to connect to MySQL.

2. Run the following SQL statement into the MySQL server you want to monitor

Mysql> GRANT PROCESS, SUPER, REPLICATION CLIENT on*.* to ' cacti ' @ ' percent ' identified by ' cacti ';

Query OK, 0 rows Affected (0.00 sec)

mysql> FLUSH privileges;

Query OK, 0 rows Affected (0.00 sec)

This will then add the MySQL monitoring in the cacti to the value of the relevant monitor.

Cacti monitoring MySQL