Why do I keep getting error messages when I try to connect to MySQL?

First thing to check is to ensure you have a valid ‘odbc.ini’ file. Depending on your system, it could be in /etc or something like /etc/unixODBC/ directories.
In this example – enter ‘fPMySQL’ in the DSN field when setting up MySQL connection in define files.

Here is a sample odbc.ini:

[fPMySQL]
Description = MySQL database
Driver = MySQL
Driver = MySQL
Server = localhost
Socket = /var/lib/mysql/mysql.sock
User = mysql_user_name
Password = secure_password
Port = 3306
Database = fptest_db