Hello.

mariadb 11.8.1

I want to use haproxy with check option.

Using in haproxy `option mysql-check` works but maridb logs:

[Warning] Aborted connection 24971 to db: 'unconnected' user: 'unauthenticated' host: '10.0.1.165' (This connection closed normally without authentication)

This is confusing as I don't know that this is regular check from haproxy, or someone tried to connect.

So I want to use in haproxy `option mysql-check user haproxy-check post-41`.

But this fails with error: [Warning] Access denied for user 'haproxy-check'@'10.0.1.164' (using password: NO)

and haproxy shows the mariadb server as DOWN.

Because in haproxy there is no way to specify a password for the user to connect to the instance of mariadb, I tried to allow passwordless access for the haproxy-check user from the specified network and minimum grants. But this does not help to allow access without password. Tried also to allow access for this user from any host and givin full access and also authentication fails.

Is there an option in mariadb that does not allow paswordless authentication?