Saturday, September 23, 2017

Error : your MySQL timezone database is not populated. in cacti

You have to set timezone for appropriate DB

#mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p cacti
Enter password:
ERROR 1146 (42S02) at line 1: Table 'cacti.time_zone' doesn't exist

Next set privilege to the cacti user for accessing the mysql db

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

no the error getting solved


No comments:

Post a Comment