Connect CentOS to MySQL ODBC
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
Related guides: MySQL Replication CentOS All Databases | Configure MySQL Multi-Master Replication