Flyway not creating the database

[mgrue]

Hello,

I followed the flyway guide (https://quarkus.io/guides/flyway) by creating a new Quarkus project. The application.properties looks like this:

quarkus.datasource.db-kind=mysql
quarkus.datasource.username=root
quarkus.datasource.password=root
quarkus.datasource.jdbc.url=jdbc:mysql://localhost:3307/mydb

quarkus.flyway.migrate-at-start=true
quarkus.flyway.default-schema=mydb

I'd expect the database to be created but when I run the application I get an error "Unknown database 'mydb'" (see stacktrace below).

Does anyone know why that happens and how I can avoid it?

Thanks
Michael

2023-02-20 17:54:52,453 ERROR [io.qua.run.Application] (Quarkus Main Thread) Failed to start application (with profile [dev]): java.sql.SQLSyntaxErrorException: Unknown database 'mydb'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:226)
at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:535)
at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:516)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)

[quarkus-bot[bot]]

/cc @cristhiank (flyway), @gastaldi (flyway), @geoand (flyway), @gsmet (flyway)

[gastaldi]

Because that would require superuser privileges, the Database creation (CREATE DATABASE) is never performed through Flyway or Quarkus.

[mgrue]

I did some more experimenting and found that if I remove the database name from the jdbc url the database gets created and the migrations are applied just as expected. But then I get an SQLException (no database selected) when I'm creating a query :/

[gastaldi]

Hm, that must be a MySQL feature then. BTW if you don't specify the quarkus.datasource.username,quarkus.datasource.password and the quarkus.datasource.jdbc.url properties Quarkus will start a MySQL container for you. See https://quarkus.io/guides/databases-dev-services

[mgrue]

I think you're right. That must be a MySQL feature. I can't get that to work with Postgres. In that case the flyway guide is a bit confusing since it never mentions database creation and the behaviour isn't documented anywhere.