title: MySQL TestContainers init-script Schema Creation Failing
body: <p>Running into the following issue trying to create a schema in a MySQL Test Containers instance. It seems like the test user doesn't have the appropriate permissions?</p>
  <p>Config:</p>
  <pre><code>spring.datasource.driver-class-name=org.testcontainers.jdbc.ContainerDatabaseDriver
  spring.datasource.url=jdbc:tc:mysql:5.7.22:///test?TC_INITSCRIPT=component/db/init_mysql.sql
  </code></pre>
  <pre><code>Caused by: org.testcontainers.ext.ScriptUtils$UncategorizedScriptException: Failed to execute database script from resource [create schema new_schema CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;]
      at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:375)
      at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:313)
      at org.testcontainers.jdbc.ContainerDatabaseDriver.runInitScriptIfRequired(ContainerDatabaseDriver.java:196)
      at org.testcontainers.jdbc.ContainerDatabaseDriver.connect(ContainerDatabaseDriver.java:132)
      at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
      at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
      at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
      at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
      at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
      ... 61 more
  Caused by: org.testcontainers.ext.ScriptUtils$ScriptStatementFailedException: Script execution failed (component/db/init_mysql.sql:1): create schema new_schema CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
      at org.testcontainers.jdbc.JdbcDatabaseDelegate.execute(JdbcDatabaseDelegate.java:49)
      at org.testcontainers.delegate.AbstractDatabaseDelegate.execute(AbstractDatabaseDelegate.java:34)
      at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:362)
      ... 69 more
  Caused by: java.sql.SQLSyntaxErrorException: Access denied for user 'test'@'%' to database 'new_schema'
      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
      at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
      at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782)
      at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
      at org.testcontainers.jdbc.JdbcDatabaseDelegate.execute(JdbcDatabaseDelegate.java:42)
      ... 71 more
  </code></pre>
  <p>component/db/init_mysql.sql</p>
  <pre><code>create schema new_schema CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  </code></pre>
  <p>Seeing similar issue when creating the mysql image outside the JDBC integration:</p>
  <pre><code>private static final MySQLContainer mysqlContainer = new MySQLContainer&lt;&gt;(DockerImageName.parse(&quot;mysql:5.7&quot;))
              .withInitScript(&quot;component/db/init_mysql.sql&quot;)
              .withUsername(&quot;user&quot;)
              .withPassword(&quot;password&quot;)
              .withExposedPorts(3306)
              .withReuse(true);
  </code></pre>
  <p>Any ideas on how I can achieve this without creating a custom docker image with the schema pre-created?</p>
  <p>Any help would be greatly appreciated I feel like I must be missing something here.</p>