Cacti 依附套件安裝完成後啟動Pre-installation, MySQL/MariaDB的ˊERROR

Install / Setting / Upgrade /HOWTO's
有關cacti的安裝設定更新問題
回覆文章
sb0526
文章: 1
註冊時間: 2017-07-05, 09:41

Cacti 依附套件安裝完成後啟動Pre-installation, MySQL/MariaDB的ˊERROR

文章 sb0526 » 2017-07-05, 09:45

小弟在CentOS Linux 7.上面安裝了cacti的軟體,利用yum安裝了相依性的套件,設定完成了,啟動Cacti的網頁時出現以下的訊息

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/MariaDB的使用者權限問題,小弟對MYSQL不了解,請問具體該在MYSQL下什麼樣的指令來解決這個問題

頭像
C.K.
Site Admin
文章: 22
註冊時間: 2015-02-25, 16:13

Re: Cacti 依附套件安裝完成後啟動Pre-installation, MySQL/MariaDB的ˊERROR

文章 C.K. » 2017-07-11, 10:58

您好,
請參考下面這一篇
https://www.ptt.cc/bbs/Linux/M.1490943297.A.14A.html

grant select on `mysql`.`time_zone_name` to `cacti`@ `localhost`
PS. to 的後面是你cacti帳號,請依照實際狀況修正。
然後記得 flush privileges

回覆文章