Setup mysql odbc on linux rhel5

download mysql odbc from http://www.mysql.com/downloads/connector/odbc/

install rpm package rpm -Uvh xxx.rpm

insert line to /etc/odbcinst.ini

# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib64/libmyodbc5-5.1.5.so <- path to mysql odbc lib
Setup = /usr/lib64/libodbcmyS.so
FileUsage = 1

insert line to /etc/odbc.ini

connector name = MyODBC 5.5 Driver DSN

[connector name]
Description = ODBC for MySQL
Driver = MySQL
SERVER = ip mysql database server
USER = user
PASSWORD =
PORT = 3306
DATABASE = database name
OPTION = 3