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