How to install MySQL JDBC and ODBC drivers version 8.0.12

The following mainly brings you the methods of installing MySQL JDBC and ODBC drivers version 8.0.12. I hope these contents can bring you practical use, which is also the main purpose of my article on how to install MySQL JDBC and ODBC drivers version 8.0.12. All right, don't talk too much nonsense, let's just read the following.

To install the JDBC and ODBC drivers, perform the following tasks:

1. Install the MySQL JDBC driver.

two。 Install the MySQL ODBC driver.

Note: the MySQL ODBC drivers you need to install vary depending on the operating system you are using. In addition, if you install a different version of the MySQL ODBC driver, you must update the DTM flag to update the MySQL ODBC driver name.

3. Restart the security agent.

Install the MySQL JDBC driver

Perform the following steps to install the MySQL JDBC driver on a Windows or Linux system:

1. Visit the following website to download the MySQL JDBC driver: https: / / downloads.mysql.com/archives/cj/ http://www.9iuf.com

two。 Select product version 8.0.12.

3. Choose the operating system as the platform independent.

4. Download the .tar or .zip file according to the Windows or Linux system.

5. Extract the downloaded file and copy the mysql-connector-java-8.0.12.jar file.

6. Remove the existing driver from the following location where the security agent reads the MySQL JDBC driver and paste the mysql-connector-java-8.0.12.jar file according to the operating system:

For Windows systems:\ apps\ Data_Integration_Server\ ext\ drivers

For Linux systems: / apps / Data_Integration_Server / ext / drivers

Note: you must copy only one MySQL JDBC driver to the location where the security agent reads the MySQL JDBC driver.

Install the MySQL ODBC driver on Windows

Perform the following steps to install the MySQL ODBC driver on Windows:

1. Visit the following website to download the MySQL ODBC driver: https: / / downloads.mysql.com/archives/c-odbc/ http://www.9iuf.com

two。 Select product version 8.0.12.

3. Select the operating system as the Microsoft Windows.

4. Select the operating system version as Windows (x86 Magi 64-bit).

5. Download ZIP archive, mysql-connector-odbc-noinstall-8.0.12-winx64.zip file.

Note: do not use the MSI installer as it removes the existing version of the MySQL ODBC driver from the system (for example, 5.3.7).

6. Extract the .zip file.

7. Open the command prompt as an administrator and navigate to the location of the extracted .zip file.

8. Run the following command at the command prompt: Install.bat

After installing the MySQL ODBC driver, check that the MySQL ODBC 8.0 Unicode driver name appears as one of the available ODBC drivers under the ODBC data Source Manager (64-bit) dialog box:

Install the MySQL ODBC driver on Linux

Perform the following steps to install the MySQL ODBC driver on Linux:

1. Click the following link to download the MySQL ODBC driver: https: / / downloads.mysql.com/archives/c-odbc/ http://www.9iuf.com

two。 Select product version 8.0.12.

Note: Informatica recommends that you use the MySQL ODBC driver version 8.0.12.

3. Select the operating system as Linux- Generic.

4. Select the operating system version to all.

5. Download the Linux-Generic (glibc 2.12) (x86 64-bit) file.

6. Extract the downloaded file to your local system and specify the extraction path in the odbcinst.ini file.

7. Edit the / odbcinst.ini file and add the following values:

[MySQL ODBC 8.0 Unicode driver]

Describe the ODBC of = MySQL

Driver = / lib/libmyodbc8w.so

Setup = / lib/libmyodbc8w.so

FileUsage = 1

In the drivers and Settings field, you must specify the file path to the libmyodbc8w.so file copied on the local system. For the above about the installation of MySQL JDBC and ODBC driver version 8.0.12, we do not find it very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.