MySQL root access is difficult to obtain

[rnorth]

Currently only a test to demonstrate #2627

[ysb33r]

I used mysql/mysql-server:5.7.30 and this fails for me due to Access denied for user 'root'@'172.17.0.1'.

It looks like .withEnv("MYSQL_ROOT_HOST", "%")will also be needed.

[rnorth]

I think this is fixed by #3953, aside from the mysql/mysql-server case. I'll rebase this PR on top of #3953 and update.

[joaocanaverde]

@rnorth @ysb33r I've tried this:

try (
            MySQLContainer<?> db = new MySQLContainer<>("mysql:5.7.36")
                .withUsername("test")
                .withPassword("test")
                .withEnv("MYSQL_ROOT_PASSWORD", "test")
                .withEnv("MYSQL_ROOT_HOST", "%")
        ) {
            db.start();

            Connection connection = DriverManager.getConnection(db.getJdbcUrl(), "root", "test");
            
            connection.createStatement().execute("SELECT 1");
            connection.createStatement().execute("set sql_log_bin=0");
        }

And I keep getting:

Access denied for user 'root'@'172.17.0.1' (using password: YES)

Using the latest version:

<dependency>
            <groupId>org.testcontainers</groupId>
            <artifactId>mysql</artifactId>
            <version>1.16.2</version>
            <scope>test</scope>
        </dependency>

Are there any other workarounds or anything I might be missing? Thanks in advance!

[ysb33r]

@rnorth @ysb33r I've tried this:

try (
            MySQLContainer<?> db = new MySQLContainer<>("mysql:5.7.36")
                .withUsername("test")
                .withPassword("test")
                .withEnv("MYSQL_ROOT_PASSWORD", "test")
                .withEnv("MYSQL_ROOT_HOST", "%")
        ) {
            db.start();

            Connection connection = DriverManager.getConnection(db.getJdbcUrl(), "root", "test");
            
            connection.createStatement().execute("SELECT 1");
            connection.createStatement().execute("set sql_log_bin=0");
        }

And I keep getting:

Access denied for user 'root'@'172.17.0.1' (using password: YES)

Using the latest version:

<dependency>
            <groupId>org.testcontainers</groupId>
            <artifactId>mysql</artifactId>
            <version>1.16.2</version>
            <scope>test</scope>
        </dependency>

Are there any other workarounds or anything I might be missing? Thanks in advance!

I don't know. I set up the database in the same way that you've done in the example and it works for me.

[rnorth]

I think for the sake of tidiness I should close this now.