Mysql ODBC

Download

• https://dev.mysql.com/downloads/connector/odbc/

Install

• dpkg -i mysql-connector-odbc_8.0.20-1ubuntu20.04_amd64.deb
• dpkg -i mysql-connector-odbc-setup_8.0.20-1ubuntu20.04_amd64.deb
• dpkg -i mysql-connector-odbc-dbgsym_8.0.20-1ubuntu20.04_amd64.deb

Konfiguration

• cat odbc.ini

[caprica]
Description           = MySQL connection to  database
Driver                = MySQL-ansi
Database              = covid19
Server                = caprica.xinux.org
User                  = root
Password              = sysadm
Port                  = 3306
#Socket                = /var/run/mysqld/mysqld.sock

• cat odbcinst.ini

[MySQL-utf]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
SETUP=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8S.so
UsageCount=1

[MySQL-ansi]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
SETUP=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8S.so
UsageCount=1