User created dont have grant privilege

[josepharuja]

mysqldConfig = aMysqldConfig(v5_7_19)
.withCharset(Charset.LATIN1)
.withPort(port)
.withUser(username, password)
.withTimeZone("Europe/London")
.withTimeout(2, TimeUnit.MINUTES)
.withServerVariable("max_connect_errors", 666)
.build();

    embeddedMysql = anEmbeddedMysql(mysqldConfig)
            .addSchema(SchemaConfig.aSchemaConfig(schemaName).build())
            .start();

    logger.info("MySQL is started with config : {}", embeddedMysql.getConfig().toString());

database starts up successfully and scripts can be run. But the create user don't have GRANT privileges

everything runs except GRANT commands

org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration a.sql failed

SQL State : 42000
Error Code : 1142
Message : GRANT command denied to user 'dev'@'localhost' for table 'y'

[viliusl]

@josepharuja - maybe you could share at least part of sql that is failing. It seems you are trying to create users or operate on information_schema because your user has ALL grant on your schema - https://github.com/wix/wix-embedded-mysql/blob/master/wix-embedded-mysql/src/main/java/com/wix/mysql/EmbeddedMysql.java#L82

[josepharuja]

Apologies for a late response.Explained in ticket #133