mysql-check only works with ancient MySQL versions

[John-Nemeth]

Detailed Description of the Problem

MySQL 8.x changed the client communication protocol. haproxy's mysql-check feature only works with versions of MySQL prior to 8.0. The last version of MySQL prior to 8.0 exited extended support more than a year ago. Plain tcpcheck causes problems as MySQL detects it as a bogus client and locks it out.

Expected Behavior

Obvious.

Steps to Reproduce the Behavior

1. Install a currently supported version of MySQL.
2. Configure haproxy to use mysql-check.

Do you have any idea what may have caused this?

No response

Do you have an idea how to solve the issue?

No response

What is your configuration?

not required

Output of haproxy -vv

not required

Last Outputs and Backtraces

Additional Information

No response

[Geun-Oh]

This could be done with small code patch of adding mysql80_req packet configuration.
@capflam May I work with this issue?

[capflam]

@Geun-Oh, of course, if you see a way to make it work with recent MySQL, go ahead

[capflam]

Support for MysqL >= 8.0 was added. I'm closing