Edited at

mysqlにmackerel用のユーザを作成して、ステータスを確認する

More than 3 years have passed since last update.


mackerel-plugin-mysql用ユーザーの作成

mysql>grant select on mysql.* to 'mackerel'@'127.0.0.1' identified by 'mackerel_password';

mysql>grant replication client on *.* to 'mackerel'@'127.0.0.1' identified by 'mackerel_password';
mysql>grant process on *.* to 'mackerel'@'127.0.0.1' identified by 'mackerel_password';
mysql>grant select on mysql.* to 'mackerel'@'localhost' identified by 'mackerel_password';
mysql>grant replication client on *.* to 'mackerel'@'localhost' identified by 'mackerel_password';
mysql>grant process on *.* to 'mackerel'@'localhost' identified by 'mackerel_password';

/usr/local/bin/mackerel-plugin-mysql -username=mackerel -password=mackerel_password