MySQL報錯ERROR 1044 ERROR 1064 (42000):

安裝監視軟體cacti時,發現mysql不能建立資料庫

mysql> create database cacti;

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'cacti'

root 使用者的 create_priv 許可權問題 重新給root設定密碼搞定>source cacti.sql;時報大量這樣錯誤ERROR 1146 (42S02): Table 'cacti.graph_templates_gprint' doesn't exist

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Stores the actual graph data.'' at line 49

是mysql5 不支援 TYPE=MyISAM  ，將cacti.sql裡面的TYPE全部換成ENGINE 即 ENGINE=MyISAM 。