How to MySQL ERROR: (1064) ?

When installed a script, I had a mysql problem,below is error message

Database setup
Trying to connect to database... Success
Detecting MySQL version... 

Executing SQL... MySQL ERROR: (1064) You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 1 
QUERY: 

CREATE TABLE `wl_admin` (`id` int(6) unsigned NOT NULL auto_increment,`username` varchar(50) NOT NULL default '',`passwd` varchar(32) NOT NULL default '',PRIMARY KEY  (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1
ERROR: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 1

Code (markup):

How to fixed it?
Thanks in advance

 

Two possible solutions:

1. I don't see a semicolon terminating your create statement
2. Not absolutely sure but I believe you need to use "ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_bin;"

 

This annoyance occurs since about one year ago with the latest phpMyAdmin versions.

Since I rarely need MySQL, the way I tackled the problem was installing an old phpMyadmin version to avoid error messages.

Not sure if that might work in your case though.

 

Solved, mysql version problem
Thanks

 

I see you fixed your problem, but still for others who have/will have this problem later, this way also works;

Change this line: ENGINE=MyISAM DEFAULT CHARSET=latin1
With this line: ENGINE=MyISAM CHARSET=latin1