root@teee:~# wget https://dev.mysql.com/get/Downloads/Connector-ODBC/8.0/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit.tar.gz
root@teee:~# tar xvf mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit.tar.gz
root@teee:~# cd mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit/lib/
root@teee:/usr/lib64# cd /usr/lib64/
root@teee:/usr/lib64# mkdir odbc
root@teee:/usr/lib64/odbc# cp /root/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit/lib/libmy* .
root@teee:/usr/lib64/odbc# ls
libmyodbc8a.so libmyodbc8S.so libmyodbc8w.so

Install:

root@teee:/usr/lib64/odbc# /root/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit/bin/myodbc-installer -d -a -n “MySQL” -t “DRIVER=/usr/lib64/odbc/ libmyodbc8w.so;”
Success: Usage count is 1

Check:

root@teee:/usr/lib64/odbc# /root/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit/bin/myodbc-installer -s -a -c2 -n “test” -t “DRIVER=MySQL;SERVER=127.0.0.1; DATABASE=mysql;UID=root;PWD=password”

[Result should be “Success”]

root@teee:/usr/lib64/odbc# ee /etc/odbcinst.ini

[MDBTools]
Description=MDBTools Driver
Driver=libmdbodbc.so
Setup=libmdbodbc.so
FileUsage=1
UsageCount=1

[MySQL]
Driver=/usr/lib64/odbc/ libmyodbc8w.so <— NEW INSTALL
UsageCount=1

Comments are closed.