phpcms2008 mysql errno : 1064_phpcms2008安装最后一步，出现1064错误。求解决。

错误提示信息如下：MySQLQuery:CREATETABLE`phpcmsz_zadmin`(`userid`mediumint(8)unsignedNOTNULL,`username`char(20)NOTNULL,`allowmultilogin`tinyint(1)unsignedNOTNULLdefault'0...

错误提示信息如下：

MySQL Query : CREATE TABLE `phpcmsz_zadmin` ( `userid` mediumint(8) unsigned NOT NULL, `username` char(20) NOT NULL, `allowmultilogin` tinyint(1) unsigned NOT NULL default '0', `alloweditpassword` tinyint(1) unsigned NOT NULL default '0', `editpasswordnextlogin` tinyint(1) unsigned NOT NULL default '0', `disabled` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`userid`)) TYPE=MyISAM DEFAULT CHARSET=latin1

MySQL Error : 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 DEFAULT CHARSET=latin1' at line 1

MySQL Errno : 1064

Message : MySQL Query Error

我试过把默认charset 改成utf-8，不行。知道这是数据库与环境配置问题，求具体的解决方法。高分哦。

展开