You must try the different dialects as follows
to see which one exactly works for you.
It seems your current dialect is generating the
type=MyISAM while it should be the
ENGINE=MyISAM in your create table query.
The mysql error 'TYPE=MyISAM'
Your logs are showing that following query was tried to be executed ,
create table MyTable (id integer not null, name varchar(255), primary key (id)) type=MyISAM
So you should try to execute the query directly on the mysql command prompt to see if that properly works for the MySQL version.
You are using the updated version of
MySQL but using the very old
You should use either,
OR below one
This will prevent you from getting the