Installing two different versions of MySQL connectors

I’m migrating from CF10/MySQL 5.1 to Lucee & MySQL 8 on a different host. I want to be able to connect to both the local MySQL 8 database and the remote MySQL 5.1 db.

If I use the MySQL 5.1.40 connector I can connect to my remote 5.1
database but not the local MySQL 8 database. If I upgrade my extensions to the 8.0.24 connector I can connect to the local MySQL 8 db, but not the remote 5.1 db.

Is there any way to run both extensions?

Thanks!

OS: Windows Server 2019
Java Version: 11.0.11
Tomcat Version: 9.0.46
Lucee Version: 5.3.8.201

Without thinking too much about it, I’d just quickly try it with the mariaDB extension, that should be compatible with MySQL 5.1.

2 Likes

It does!

Thanks so much

1 Like