CentOS7.6最简ODBC配置访问TiDB配置

1，安装odbc

sudo yum install unixODBC unixODBC-devel mysql-connector-odbc

确认安装成功

[tidb@vm10-2-103-12 ~]$ isql --verison
unixODBC 2.3.1

确认/usr/lib64/libmyodbc9w.so存在

2，配置odbc.ini, 如无新建并保存和修改如下配置。

sudo vi /etc/odbc.ini

[mysql]
Description=MySQL test database
Trace=Yes
TraceFile=mysql_sql.log
Driver=/usr/lib64/libmyodbc9w.so
SERVER=10.2.103.12
USER=root 
PASSWORD=
PORT=4100
DATABASE=test

注意：配制一个odbc.ini文件简单直接，不容易出错。

3， 确认访问：

[tidb@vm10-2-103-12 ~]$ sudo vi /etc/odbc.ini
[tidb@vm10-2-103-12 ~]$ isql mysql -v 
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> show databases;
+--------------------+
| Database           |
+--------------------+
| INFORMATION_SCHEMA |
| METRICS_SCHEMA     |
| PERFORMANCE_SCHEMA |
| base               |
| his                |
| lightning_task_info|
| mysql              |
| report             |
| syss               |
| tem                |
| test               |
| tpcc               |
+--------------------+
SQLRowCount returns 12
12 rows fetched
SQL> use test 
SQLRowCount returns 0
SQL> show tables;
+---------------+
| Tables_in_test|
+---------------+
| A             |
| customer      |
| district      |
| history       |
| item          |
| new_order     |
| order_line    |
| orders        |
| sbtest1       |
| sbtest2       |
| sbtest3       |
| sbtest4       |
| sbtest5       |
| stock         |
| t             |
| t10           |
| testTM        |
| test_a        |
| test_b        |
| v11           |
| warehouse     |
+---------------+
SQLRowCount returns 21
21 rows fetched
SQL> select * from sbtest1 limit 2;
+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------+
| id        | k         | c                                                                                                                                                                                                                                                               | pad                                                             |
+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------+
| 1         | 1999      | cbdf4740-27af-11ef-9665-fa163e2fa0f2cbdf49c9-27af-11ef-9665-fa163e2fa0f2cbdf49d1-27af-11ef-9665-fa163e2fa0f2                                                                                                                                                    | cbdf4a00-27af-11ef-9665-fa163e2fa0f2                            |
| 2         | 1999      | d3b32101-27af-11ef-9665-fa163e2fa0f2d3b3210d-27af-11ef-9665-fa163e2fa0f2d3b3211f-27af-11ef-9665-fa163e2fa0f2                                                                                                                                                    | d3b3215d-27af-11ef-9665-fa163e2fa0f2                            |
+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------+
SQLRowCount returns 2
2 rows fetched