download the appropriate RPM (v8.0.27) from
https://dev.mysql.com/downloads/connector/odbc/
Installing the RPM adds the following to /etc/odbcinst.ini:
[MySQL ODBC 8.0 Unicode Driver]
Driver=/usr/lib64/libmyodbc8w.so
SETUP=/usr/lib64/libmyodbc8S.so
UsageCount=1
[MySQL ODBC 8.0 ANSI Driver]
Driver=/usr/lib64/libmyodbc8a.so
SETUP=/usr/lib64/libmyodbc8S.so
UsageCount=1
Here is a typical DSN:
[mysql-myhost]
Driver = MySQL ODBC 8.0 Unicode Driver
Server = myhost
Database = mydb
Port = 3306
Caveat: Problems have been reported with MySQL 8.0.28 and later. We recommend using 8.0.27.