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?
OS: Windows Server 2019
Java Version: 11.0.11
Tomcat Version: 9.0.46
Lucee Version: 184.108.40.206