mysql5.5.x 安装cacti报语法错误

  安装cacti时,在导入cacti.sql 这个文件时报错:

The command "mysql -u root -p cacti < cacti.sql' gets the following error:
ERROR 1064 (42000) at line 5: 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' at line 6
 

   

    原因是mysql5这后不再支持 TYPE=MyISAM  这样的语法了,改成  ENGINE=MyISAM 就可以了。

原文地址:https://www.cnblogs.com/jmax/p/2073666.html