MySqlConnector: Connection is reset to SET NAMES utf8mb4 COLLATE utf8mb4_general_ci and cannot be changed

Since MySql 8.0.1, default collation is utf8mb4_0900_ai_ci. Current implementation of connection reset executes SET NAMES utf8mb4 COLLATE utf8mb4_general_ci; and it cannot be changed.

Is it possible to change this behaviour and be able to set charset and collation from connection string?

I’m more than willing to provide a pull request.

Thanks!