In version 3.8 we upgraded the MySQL JDBC driver to version 8.0.16, so that the latest MySQL 8.x can be used. However the new driver doesn't support versions of MySQL older than 5.6. Since these older versions are over 10 years old and are already listed as End-Of-Life by Oracle, we have made the decision to adjust our system requirements to reflect that 5.6+ is now the minimum supported version for MySQL.
If you still need to connect to an older version of MySQL, do not worry you still can!
Connecting via a Database Reader/Writer or in JavaScript
- Download the appropriate MySQL JDBC Driver JAR for the version of MySQL you need to connect to.
- Place this JAR into a folder of your choice on the system running Mirth Connect.
- Create a new library resource (Settings -> Resources tab) pointing to that folder.
- Link your connector/channel to your new resource (Summary tab -> Set Dependencies).
- Make sure you are using the old driver class name, "com.mysql.jdbc.Driver".
Using an Old Version of MySQL for Your Connect Backend Database
- Download the appropriate MySQL JDBC Driver JAR for the version of MySQL you need to connect to.
- Swap this JAR with the MySQL 8.x driver in the "server-lib/database" folder in your installation directory.
- Set "database.driver = com.mysql.jdbc.Driver" in mirth.properties.
- Make sure that any Database Reader/Writer connectors that are connecting to the old version of MySQL use the old driver class name, "com.mysql.jdbc.Driver".
If you need to use an old version of MySQL for the backend database and also need to connect to newer MySQL 8.x+ databases as well, you can follow the steps in the section above to include the 8.x JDBC driver as a custom resource.
