MySQL¶
Installing the MySQL connector¶
FMR needs a connector for MySQL called MySQL Connector/J which can be downloaded directly from the MySQL distribution site.
The driver itself is a single 'jar' file named mysql-connector-java-9.6.0.jar or similar and must be installed by copying into the FMR's Tomcat deployment WEB-INF/lib directory, or by placing in a separate directory and adding that to the Java CLASSPATH.
Locate the tomcat directory and copy the connector's 'jar' file into the tomcat/webapps/ROOT/WEB-INF/lib directory.
Create a suitable directory and copy in the connector's 'jar' file. For instance /usr/local/lib/mysql-connector-java-9.6.0.jar.
Refer to the Setting JAVA_OPTS and CLASSPATH environment variables for guidance on how to add the directory to the Java CLASSPATH.
Connection Details¶
| Parameter | Value |
|---|---|
| Default port | 3306 |
| Connection String | jdbc:mysql://[serverName[:portNumber]][;property=value[;property=value]] |
| Class Name | com.mysql.cj.jdbc.Driver |