I installed WikkaWiki on a server with MySQL 5.5.29 and it failed to create all the needed tables, without any more information on screen. After checking the authorization and finding no issue, I recopied the create table statement in PHPMyAdmin and found "an error near Type=MyISAM".
It appears that TYPE keyword in CREATE TABLE was deprecated long ago, and should be replaced with ENGINE. The statement should be
CREATE TABLE tablename ( fieldname INT ) ENGINE=MyISAM
However, MySQL documentation says that it is unnecessary to use ENGINE to specify the MyISAM storage engine because MyISAM is the default engine anyway. Fortunately, WikkaWiki tables are all MyISAM, so the best option was to simply remove it.