1、修改数据源
vi /etc/apt/source.list
添加 deb http://cz.archive.ubuntu.com/ubuntu lucid main universe
保存
sudo apt-get update
2、安装unixODBC
sudo apt-get install unixODBC
注:没有上一步,会提示没有unixODBC软件包
3、安装数据库
sudo apt-get install mysql-server mysql-client
4、安装mysql的odbc驱动
apt-get install libmyodbc
5、配置(/etc/odbcinst.ini 和 /etc/odbc.ini)
vi /etc/odbcinst.ini
添加
[MySQL]
Description = MySQL
Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so (有可能路径不同,自己搜索一下)
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1vi /etc/odbc.ini
[MySql]
Driver = MySQL(与配置的一致)
Description = MySQL ODBC 3.51 Driver DSN
Server = localhost
Port = 3306
User = root
Password = root
Database = test(需要自己创建数据库test)
Option = 3
Socket =
6、测试
isql MySql root root
打印出:+—————————————+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+—————————————+