hibernate (6) mysql (8) [hibernate can't create the table:

[John Brown jr]

hibername: hi;
Using macos ;

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>

and also :

<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/mydb?createDatabaseIfNotExist=true"/>

inside eclipse.
the short of the story is this:
running my project would even create a mydb database if it idoesn'texist and also even drop table (mytable) if it exists but doesn't create it:

ERROR: Table 'mydb.mytable' doesn't exist
Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement

Caused by: java.sql.SQLSyntaxErrorException: Table 'mydb.mytable' doesn't exist