I am currently experiencing an issue while attempting to connect to my MySQL database hosted on Aiven.
The error message I am encountering is as follows:
ERROR 2007 (HY000): Protocol mismatch; server version = 11, client version = 10
I have tried connecting using MySQL client versions 8.0 and 8.4 on a Debian 11 system, but both attempts resulted in the same protocol mismatch error.
Here is the command I used for the connection attempt:
mysql --host=myhost-db.e.aivencloud.com --port=18553 --user=avndadmin --password=‘my_password’ --ssl-ca=/var/www/adminer/ca-cert.pem --ssl-cert=/var/www/adminer/client-cert.pem --ssl-key=/var/www/adminer/client-key.pem --ssl-cipher=‘TLS_AES_128_GCM_SHA256’
I suspect that there might be a protocol version incompatibility between the client and the server.
Could you please assist me in resolving this issue?