Connect CentOS to MySQL ODBC

There are many uses for this, usually reporting, or some other data manipulation. Let’s get started, login and su to root

install some basic tools

view the basics of your config in a nice info file

view the ODBC config instance file, this is for different database types

as you can see MySQL and PostgreSQL are allready configured

from here we need to create specific instances/connections.

here’s a look at a sample ODBC connection config

save + quit

from here install the ODBC driver, and install SystemDSN

test the connection using the Database name {space} username

as we can see basic SQL Queries work

that’s it!

Hosted Linux Servers at www.zwiegnet.com/go