在安装cacti时,有一段报错
1 |
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. |
解决办法:登录mysql,执行以下内容
1 2 |
mysql> GRANT SELECT ON mysql.time_zone_name TO cacti@localhost IDENTIFIED BY 'cactiwhsir'; mysql> flush privileges; |
然后发现又报错
1 |
ERROR: Your MySQL TimeZone database is not populated. Please populate this database before proceeding. |
解决办法:执行以下内容
1 |
/usr/local/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -uroot -p mysql |
原文链接:cacti安装时报错MySQL TimeZone database,转载请注明来源!