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
#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