Solution:
You must try the different dialects as follows
org.hibernate.dialect.MySQL5Dialect
or org.hibernate.dialect.MySQLMyISAMDialect
or org.hibernate.dialect.MySQLInnoDBDialect
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.
OR
You are using the updated version of MySQL
but using the very old dialect
You should use either,
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
OR below one
<property name="hibernate.dialect">org.hibernate.dialect.MySQL8Dialect</property>
in your hibernate.cfg.xml
file.
This will prevent you from getting the dialect
issues