I want to know the correspondence between proxysql version, jdbc mysql driver version and mysql version

sysown / proxysql

High-performance MySQL proxy with a GPL license.

http://www.proxysql.com

GNU General Public License v3.0

6.05k stars 983 forks source link

I want to know the correspondence between proxysql version, jdbc mysql driver version and mysql version #4655

Closed suyestyle closed 2 months ago

suyestyle commented 2 months ago

mysql version 8.0.35 proxysql version 2.3.2-10-g8cd66cf jdbc mysql driver version 8.0.29

I encountered a problem today when I used jdbc to connect proxysql and reported the following error

Failed to initialize pool: Could not create connection to database server.

After I changed the jdbc driver version to 5.6, I was able to connect proxysql to mysql normally.

What is the reason for this? Can you provide a version mapping table between components

renecannao commented 2 months ago

There is no such thing as a version mapping table, all versions can connect to all versions with the correct configuration.

Why you couldn't connect? I don't know, but it is unlikely to be just the version: it could be authentication plugin, it could be TLS settings, or anything else.