Shulou(Shulou.com)06/01 Report--

This article mainly introduces the use of MySQL unixODBC process analysis, the content of the article is carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the next topic content.

The use of unixODBC in MySQL 1. Download unixODBC source code installation package extract source code installation package tar-zxvf unixODBC-2.3.4.tar.gz-C / usr/local/cd / usr/local/unixODBC-2.3.4# default installation location is / usr/local. / configuremakemake install extract MySQL odbc file tar-zxvf mysql-connector-odbc-5.3.9-linux-glibc2.12-x86-32bit.tar.gz-C / usr/local/mv mysql-connector-odbc-5. 3.9-linux-glibc2.12-x86-32bit mysql-odbccd mysql-odbccp bin/* / usr/local/bin/cp lib/* / usr/local/lib modifies the environment variable export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH registration driver myodbc-installer-a-d-n "MySQL ODBC 5.3 Driver"-t "Driver=/usr/local/lib/libmyodbc5w.so" configuration ODBC configuration file Change vim odbc.ini [myodbc3] Driver = / usr/local/lib/libmyodbc5w.soDescription = Connector/ODBC 3.51 Driver DSNSERVER = localhostPORT = 3306USER = rootPassword = mysql123Database = hiveOPTION = 3SOCKET = test connectivity isql myodbc3-VOBC3- -+ | Connected! | sql-statement | | help [tablename] | | quit | | +- -- + SQL >

If it is displayed normally, it is successful.

After reading the above analysis of the use process of MySQL's unixODBC, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.