『heqingchun-Qt使用MySQL数据库配置』

ubuntu编译qt使用的libqsqlmysql.so库文件

一、x86

前提:电脑安装

sudo apt install mysql-client libmysqlclient-dev

old='QMAKE_USE += mysql' && \
new='#QMAKE_USE += mysql'

sudo sed -i "s/$old/$new/g" /opt/Qt5.12.9/5.12.9/Src/qtbase/src/plugins/sqldrivers/mysql/mysql.pro

old='qtsqldrivers-config' && \
new='configure'

sudo sed -i "s/$old/$new/g" /opt/Qt5.12.9/5.12.9/Src/qtbase/src/plugins/sqldrivers/qsqldriverbase.pri

cd /opt/Qt5.12.9/5.12.9/Src/qtbase/src/plugins/sqldrivers/mysql/

sudo /opt/Qt5.12.9/5.12.9/gcc_64/bin/qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/x86_64-linux-gnu/ -lmysqlclient" mysql.pro

sudo make

sudo make install

参考:https://blog.csdn.net/weixin_45848751/article/details/117989901?spm=1001.2014.3001.5506

二、AArch64

1.编译AArch64版本qt

链接: ubuntu交叉编译arm版本Qt

2.下载mysql资源

链接: 官方下载地址
下载得到如下文件:“mysql-8.0.34-linux-glibc2.17-aarch64.tar”，解压文件得到三个压缩文件:“mysql-8.0.34-linux-glibc2.17-aarch64.tar.gz”、“mysql-test-8.0.34-linux-glibc2.17-aarch64.tar.gz”、“mysql-router-8.0.34-linux-glibc2.17-aarch64.tar.gz”，继续解压“mysql-8.0.34-linux-glibc2.17-aarch64.tar.gz”得到目录"mysql-8.0.34-linux-glibc2.17-aarch64"，将目录放置"/usr/local"目录下。

3.编译AArch64版qt使用的mysql库

old='QMAKE_USE += mysql' && \
new='#QMAKE_USE += mysql'

sudo sed -i "s/$old/$new/g" /opt/qt-everywhere-src-5.12.9/qtbase/src/plugins/sqldrivers/mysql/mysql.pro

old='qtsqldrivers-config' && \
new='configure'

sudo sed -i "s/$old/$new/g" /opt/qt-everywhere-src-5.12.9/qtbase/src/plugins/sqldrivers/qsqldriverbase.pri

cd /opt/qt-everywhere-src-5.12.9/qtbase/src/plugins/sqldrivers/mysql

sudo /opt/Qt5.12.9-arm/bin/qmake "INCLUDEPATH+=/usr/local/mysql-8.0.34-linux-glibc2.17-aarch64/include/mysql" "INCLUDEPATH+=/usr/local/mysql-8.0.34-linux-glibc2.17-aarch64/include" "LIBS+=-L/usr/local/mysql-8.0.34-linux-glibc2.17-aarch64/lib -lmysqlclient" mysql.pro

sudo make

sudo make install