标题:求在Ubuntu和嵌入式ARM开发板上分别安装mysql客户端的方法
作者:yuxuan
日期:2009-10-26 13:35
内容:
本人在windows操作系统上安装了mysql 5.1软件，想在虚拟机的Ubuntu操作系统和嵌入式ARM开发板上分别访问windows上的MySQL数据库，请问要怎么做？
在Ubuntu下sudo apt-get install mysql-client就可以了吗？或者安装mysql-gui-tools-5.0r12-linux-i386.tar.gz对吗？
那ARM开发板上Qt程序连接MySQL需要做些什么呢？请版主大人帮帮忙？
#1 [yuxuan 10-27 17:05]
1、在Ubuntu下“sudo apt-get install mysql-client” 安装mysql客户端，同时安装图形界面管理查询工具“mysql-gui-tools-5.0r12-linux-i386.tar.gz”；
2、编译Linux下的mysql驱动，按照Qt文档“SQL Database Drivers“的说明，安装mysql-devel，
输入sudo apt-get install mysql-devel 提示没有这个包，sudo apt-get install libmysqlclient15-dev，
用 dpkg -L libmysqlclient15-dev | more查看包安装位置
cd /qtx11安装源文件位置/src/plugins/sqldrivers/mysql
qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro
make
sudo make install
结果生成驱动 /usr/local/Trolltech/Qt-4.5.0/plugins/sqldrivers/libqsqlmysql.so
3、编译ARM下的mysql驱动
cd /qte安装源文件位置/src/plugins/sqldrivers/mysql
qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/libmysqlclient_r.a" mysql.pro
make
sudo make install
以上编译的libqsqlmysql.so在ARM开发板上运行会出问题，说明编译错误，可是按照
qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib -lmysqlclient_r" mysql.pro
make不通过，提示
/usr/local/arm/4.3.2/bin/../lib/gcc/arm-none-linux-gnueabi/4.3.2/../../../../arm-none-linux-gnueabi/bin/ld: skipping incompatible /home/mysql/libmysqlclient_r.a when searching for -lmysqlclient_r
/usr/local/arm/4.3.2/bin/../lib/gcc/arm-none-linux-gnueabi/4.3.2/../../../../arm-none-linux-gnueabi/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status
该怎么办呢？
#2 [yuxuan 10-28 10:54]
/usr/local/arm/4.3.2/bin/../lib/gcc/arm-none-linux-gnueabi/4.3.2/../../../../arm-none-linux-gnueabi/bin/ld: warning: library search path "/usr/lib/" is unsafe for cross-compilation
/usr/local/arm/4.3.2/bin/../lib/gcc/arm-none-linux-gnueabi/4.3.2/../../../../arm-none-linux-gnueabi/bin/ld: skipping incompatible /usr/lib//libmysqlclient_r.so when searching for -lmysqlclient_r
/usr/local/arm/4.3.2/bin/../lib/gcc/arm-none-linux-gnueabi/4.3.2/../../../../arm-none-linux-gnueabi/bin/ld: skipping incompatible /usr/lib//libmysqlclient_r.a when searching for -lmysqlclient_r
/usr/local/arm/4.3.2/bin/../lib/gcc/arm-none-linux-gnueabi/4.3.2/../../../../arm-none-linux-gnueabi/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status
make: *** [../../../../plugins/sqldrivers/libqsqlmysql.so] 错误 1