Unable to create more than one database in same server (MySQL)

@mtmanju for some reason there has been a change in some defaults of the MySQL JDBC Driver. More precisely in the nullCatalogMeansCurrent property.

In 5.1 the property default value is true. Which means that the catalog would match the current database in the URL. In 8.0 they changed this to false. Which means that it won’t match it.

In order to make this work on 8.0 you would need to add nullCatalogMeansCurrent=true to your JDBC URL.

See https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html
and https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html

In the meantime we are also going to look into if we can do something about this on our side.

6 Likes