{"id":91,"date":"2019-11-29T19:35:49","date_gmt":"2019-11-30T02:35:49","guid":{"rendered":"http:\/\/naitinoi.com\/?p=91"},"modified":"2019-11-29T19:35:49","modified_gmt":"2019-11-30T02:35:49","slug":"install-mysql-odbc-connector-to-debian-10-x","status":"publish","type":"post","link":"https:\/\/omtel.ltd\/index.php\/2019\/11\/29\/install-mysql-odbc-connector-to-debian-10-x\/","title":{"rendered":"INSTALL MYSQL ODBC CONNECTOR TO DEBIAN 10.x"},"content":{"rendered":"\n<p>root@teee:~# wget https:\/\/dev.mysql.com\/get\/Downloads\/Connector-ODBC\/8.0\/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit.tar.gz<br>\nroot@teee:~# tar xvf mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit.tar.gz<br>\nroot@teee:~# cd mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit\/lib\/<br>\nroot@teee:\/usr\/lib64# cd \/usr\/lib64\/<br>\nroot@teee:\/usr\/lib64# mkdir odbc<br>\nroot@teee:\/usr\/lib64\/odbc# cp \/root\/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit\/lib\/libmy* .<br>\nroot@teee:\/usr\/lib64\/odbc# ls<br>\nlibmyodbc8a.so  libmyodbc8S.so  libmyodbc8w.so<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Install:<\/h2>\n\n\n\n<p>root@teee:\/usr\/lib64\/odbc# \/root\/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit\/bin\/myodbc-installer -d -a -n &#8220;MySQL&#8221; -t &#8220;DRIVER=\/usr\/lib64\/odbc\/ libmyodbc8w.so;&#8221;<br>\nSuccess: Usage count is 1<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Check:<\/h2>\n\n\n\n<p>root@teee:\/usr\/lib64\/odbc#  \/root\/mysql-connector-odbc-8.0.18-linux-debian10-x86-64bit\/bin\/myodbc-installer -s -a -c2 -n &#8220;test&#8221; -t &#8220;DRIVER=MySQL;SERVER=127.0.0.1; DATABASE=mysql;UID=root;PWD=password&#8221;<\/p>\n\n\n\n<p>[Result should be \u201cSuccess\u201d]<\/p>\n\n\n\n<p>root@teee:\/usr\/lib64\/odbc# ee \/etc\/odbcinst.ini<\/p>\n\n\n\n<p>[MDBTools]<br>\nDescription=MDBTools Driver<br>\nDriver=libmdbodbc.so<br>\nSetup=libmdbodbc.so<br>\nFileUsage=1<br>\nUsageCount=1<\/p>\n\n\n\n<p>[MySQL]<br>\nDriver=\/usr\/lib64\/odbc\/ libmyodbc8w.so                    &lt;&#8212; NEW INSTALL<br>\nUsageCount=1<\/p>\n","protected":false},"excerpt":{"rendered":"<p>root@teee:~# wget https:\/\/dev.mysql.com\/get\/Downloads\/C [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":3,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":1066,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/posts\/91\/revisions\/1066"}],"wp:attachment":[{"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/omtel.ltd\/index.php\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}