Connect to MySQL w/o password

[erycson]

Hi guys,

Today I met an issue to connect to MySQL Server 5.7.17 using account w/o password. I got next log error:

Error 1045 - #28000 - Access denied for user 'root'@'localhost' (using password: YES)

My conf.json:

{
    "database": {
        "host": "127.0.0.1",
        "port": 3306,
        "maxPoolSize": 1,
        "username": "root",
        "password": "",
        "database": "testdb"
    }
}

Java:

        SQLClient client = MySQLClient.createNonShared(vertx, config().getJsonObject("database"));
        client.getConnection(result -> {
            if (result.failed()) {
                logger.info("ERROR");
                fut.fail(result.cause());
            } else {
                logger.info("OK");
            }
        });

P.S. I'm using Vertx 3.4.2, vertx-mysql-postgresql-client 3.4.2.

[Narigo]

Did you try not to provide the line "password": "", in your JSON?

[erycson]

Give the same error

[Narigo]

I've tried to set String DEFAULT_PASSWORD = null; instead of String DEFAULT_PASSWORD = "password"; in io.vertx.ext.asyncsql.MySQLClient, which showed errors in test com.github.mauricio.async.db.mysql.exceptions.MySQLException: Error 1045 - #28000 - Access denied for user 'vertx'@'localhost' (using password: NO). I've tried a few variations on docker run commands for MySQL but could not manage to connect to one. Can you try to change the line mentioned above and see if it would work with your setup?

[thesowah]

Try to set the password to null instead of the empty string
{
"database": {
"host": "127.0.0.1",
"port": 3306,
"maxPoolSize": 1,
"username": "root",
"password": null,
"database": "testdb"
}
}