Cacti対応

time_zone_name mysql Please provide the Cacti database account “select” access to

vi /etc/my.cnf and add bellow lines.

[mysqld]
default_time_zone=Europe/Paris

ERROR: Your Cacti database login account does not have access to the MySQL TimeZone database. Please provide the Cacti database account “select” access to the “time_zone_name” table in the “mysql” database, and populate MySQL’s TimeZone information before proceeding.

ERROR: Your MySQL TimeZone database is not populated. Please populate this database before proceeding.

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

mysql> GRANT ALL PRIVILEGES ON mysql.* TO ‘cacti’@’localhost’ WITH GRANT OPTION;

grant select on mysql.time_zone_name to cacti@localhost;
grant select on mysql.time_zone_name to cactiuser@localhost;
flush privileges;

シェアする

  • このエントリーをはてなブックマークに追加

フォローする