Install the MySQL JDBC Driver

To ensure compliance with MySQL licensing restrictions, the MySQL Java Database Connectivity (JDBC) driver is no longer bundled with WHD.

If your deployment is connected to a MySQL database (which is used by certain asset discovery connections), download the MySQL JDBC driver from the MySQL Community Downloads website.

After you unpack the ZIP or TAR archive, install the driver on your Windows, macOS, or Linux system.

The lowest version you can run in your WHD deployment is Connector/J 5.1.27. Be aware that SolarWinds does not support this connector.

Beginning with WHD 12.7.1, Oracle Java is replaced with the Open Java Development Kit (OpenJDK)—a free and open-source implementation of the Java Platform. This update modifies the directory structure where the MySQL JDBC driver is installed. To prevent errors after an upgrade, install the driver on your host server as described below. To install the MySQL JDBC Driver in versions prior to WHD 12.7.1, see the WHD Administrator Guide for the previous version.

Download the driver

The following procedures explain how to download the driver for WHD servers running MySQL 5.7 and MySQL 8.0. Select the procedure based on your configuration.

Download the driver for MySQL 5.7

1. Navigate to the MySQL Community Downloads website. located at:

   https://dev.mysql.com/downloads/connector/j/

2. Click the Archives tab.

3. Click the Product Version drop-down menu and select 5.1.46.

   The Operating System drop-down menu automatically selects Platform Independent for you.

4. Download the ZIP archive (for Windows) or TAR archive (for Linux and macOS).
5. Unpack the archive file using WinZIP (for Windows) or another utility.

6. Locate the following JDBC driver inside the archive:

   mysql-connector-java.5.1.46.jar

7. Install the driver on your Windows, macOS or Linux system.

Download the driver for MySQL 8.0

1. Navigate to the MySQL Community Downloads website. located at:

   https://dev.mysql.com/downloads/connector/j/

2. In the General Availability (GA) Release tab, click the drop-down menu and select the operating system as Platform Independent.

   WHD supports the MySQL 8.2.0.
3. Click Go to Download Page.

4. Download the ZIP archive (for Windows) or TAR acrhive (for Linux or macOS).

5. Unpack the archive file using WinZIP (for Windows) or another utility.

6. Locate the JDBC driver inside the archive.

7. Install the driver on your Windows or Linux or macOS system.

Install the driver

Install the driver on your Windows, macOS or Linux system.

Install the driver on a Windows system

1. Log in to the server hosting Web Help Desk.

2. Navigate to the targeted directory.

   If you are running Web Help Desk 12.6 and below, navigate to:

   <webhelpdesk>\bin\jre\lib\ext

   If you are running Web Help Desk 12.7 and later, navigate to:

   <webhelpdesk>\bin\webapps\helpdesk\WEB-INF\lib

3. Copy the JDBC driver file into the lib directory.

4. Restart Web Help Desk.

   The MySQL JDBC driver is installed on your system.

Install the driver on a macOS system

1. Log in to the server hosting Web Help Desk.

2. Navigate to the targeted directory.

   If you are running Web Help Desk 12.6 and below, navigate to:

   <webhelpdesk>/bin/jre/lib/ext

   If you are running Web Help Desk 12.7 and later, navigate to:

   <webhelpdesk>/bin/webapps/helpdesk/WEB-INF/lib

3. Copy the JDBC driver into lib directory.

4. Restart Web Help Desk.

   The MySQL JDBC driver is installed on your system.

Install the driver on a Linux system

1. Log in to the server hosting Web Help Desk.

2. Navigate to the targeted directory.

   If you are running Web Help Desk 12.6 and below, navigate to:

   <webhelpdesk>/bin/jre/lib/ext

   If you are running Web Help Desk 12.7 and later, navigate to:

   <webhelpdesk>/bin/webapps/helpdesk/WEB-INF/lib

3. Copy the JDBC driver into the lib directory.

4. Restart Web Help Desk.

   The MySQL JDBC driver is installed on your system.