ODBC installation and configuration


warning

Make sure to install a supported version of MySQL Server and ODBC Connector.


note

You can install the Microsoft ODBC driver (version 13 and later) to connect the ESET PROTECT Server on Linux to Microsoft SQL Server on Windows. For more information, visit this Knowledgebase article.

Install the MySQL ODBC driver using the Terminal. Follow the steps for your Linux distribution:

Debian, Ubuntu

CentOS 7

Other supported Linux distributions

Debian, Ubuntu

1.Install unixODBC drivers:

sudo apt-get install unixodbc

2.Download the ODBC connector:

Ubuntu 16

wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-ubuntu16.04-x86-64bit.tar.gz

Ubuntu 18

wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-ubuntu18.04-x86-64bit.tar.gz

Ubuntu 20

wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit.tar.gz

Debian 10

wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-debian10-x86-64bit.tar.gz


warning

Select and download the version compatible with your Linux distribution and version.

You can download the ODBC connector for MySQL from the official MySQL site.

3.Unzip the ODBC driver archive (package name changes depending on link used):

gunzip mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit.tar.gz

4.Extract the ODBC driver (package name changes depending on link used):

tar xvf mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit.tar

5.Navigate to the ODBC driver folder (package name changes depending on link used):

cd mysql-connector-odbc-8.0.17-linux-ubuntu19.04-x86-64bit

6.Copy ODBC driver files:

sudo cp bin/* /usr/local/bin

sudo cp lib/* /usr/local/lib

7.Register the driver for ODBC.

For new Linux versions like Ubuntu 20.x, we recommend using the Unicode driver:

sudo myodbc-installer -a -d -n "MySQL ODBC 8.0 Driver" -t "Driver=/usr/local/lib/libmyodbc8w.so"

For other systems, or when Unicode driver is not working, use this command:

sudo myodbc-installer -a -d -n "MySQL ODBC 8.0" -t "Driver=/usr/local/lib/libmyodbc8a.so"

8.List the installed drivers:

sudo myodbc-installer -d -l

For more information, see https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-unix-tarball.html.

CentOS 7

1.Install unixODBC drivers:

sudo yum install unixODBC -y

2.Download the ODBC connector:

wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-1.el7.x86_64.rpm


warning

Do not install the ODBC connector using YUM - it would install the latest, not compatible version.

Select and download the version compatible with your Linux distribution and version.

You can download the ODBC connector for MySQL from the official MySQL site.

3.Install the ODBC driver:

sudo rpm -ivh mysql-connector-odbc-8.0.17-1.e17.x86_64.rpm --nodeps

4.Set up the ODBC driver:

sudo myodbc-installer -a -d -n "MySQL ODBC 8.0.17" -t "Driver=/usr/lib64/libmyodbc8w.so"

5.List the installed drivers:

sudo myodbc-installer -d -l

Other supported Linux distributions


warning

Select and download the version compatible with your Linux distribution and version.

You can download the ODBC connector for MySQL from the official MySQL site.

1.Follow these instructions to install the ODBC driver:

OpenSuse, SUSE Linux Enterprise Server: sudo zypper install unixODBC. See also https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-unix-rpm.html

Installing Connector/ODBC from a Binary Tarball Distribution

2.Run the following command to open the odbcinst.ini file in a text editor:

sudo nano /etc/odbcinst.ini

or sudo nano/etc/unixODBC/odbcinst.ini

3.Copy the following configuration into the odbcinst.ini file (make sure the paths to Driver and Setup are correct), then save and close the file:

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

The Driver may be in a different location for some distributions. You can find the file using the following command:

sudo find /usr -iname "*libmyodbc*"

4.Update the configuration files that control ODBC access to database servers on the current host by running the following command:

sudo odbcinst -i -d -f /etc/odbcinst.ini

or sudo odbcinst -i -d -f /etc/unixODBC/odbcinst.ini