我已经编译好的qt mysql驱动在 http://download.csdn.net/source/2794174
这个编译的过程如下:
首先安装QT creator,我用的版本是2010.05,并且已经集成了mingw32
1.下载mysql的sdk并安装,http://www.mysql.com/downloads/connector/cpp/
2.在c盘下,新建C:/mysql/MySQL51目录,后将C:/Program Files/MySQL/MySQL Connector C 6.0.2下的include和lib目录拷贝过去。
3.下载一个DEV-CPP,安装后把c:/dev-cpp/bin加入到系统环境变量的path中
4.下载动态库格式转换工具http://www.qtcn.org/download/mingw-utils-0.3.tar.gz ,把reimp.exe解压到dev-cpp/bin目录下
5.到cmd命令行下,执行 cd C:/mysql/MySQL51/opt/,进入mysql的库目录下,执行reimp -d libmysql.lib将其转换为libmysql.def,再执行dlltool -k -d libmysql.def -l libmysql.a
6.单击屏幕左下角“开始”按钮,进入“Qt SDK by Nokia v2010.05 (open source)”,选择“Qt Command Prompt”,进入qt自带的命令行,执行configure.exe -debug-and-release -platform win32-g++ -qt-sql-mysql -l mysql -I C:/MySQL/MySQL51/include -L C:/MySQL/MySQL51/lib/opt,之后是漫长的等待...,
再执行mingw32-make sub-src,之后是更漫长的等待...
7.完成后,进入C:/Qt/2010.05/qt/src/plugins/sqldrivers/mysql,输入qmake -o Makefile "INCLUDEPATH+=C:/MYSQL/MYSQL51/INCLUDE" "LIBS+=C:/MYSQL/MYSQL51/LIB/OPT/LIBMYSQL.a" mysql.pro
8.输入mingw32-make
9.编译完成后在C:/Qt/2010.05/qt/plugins/sqldrivers/就会多出
- libqsqlmysql4.a
- libqsqlmysqld4.a
- qsqlmysql4.dll
- qsqlmysqld4.dll
编译就成功了。另外还要把C:/MySQL/MySQL51/lib/opt/libmysql.dll 文件拷贝的c:/qt/2010.05/qt/bin下面。然后就可以写qt连接mysql的程序了,但是这时候也有个问题,就是编译会报错找不到mysql.h,我用的方法是把c:/mysql/mysql51/include中的所有文件,拷贝到了C:/Qt/2010.05/qt/include/QtSql
参考:http://student.csdn.net/space.php?uid=32341&do=blog&id=10663