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 。