ubuntu 22 下qt5.15编译mysql驱动

安装mysql开发库

apt-get install libmysqlcppconn-dev
apt-get install libmysqlclient-dev

下面的所有命令用root身份执行

启动qtcreator

/opt/Qt/Tools/QtCreator/bin/qtcreator.sh

打开如下工程：

/opt/Qt/5.15.2/gcc_64/plugins/sqldrivers/mysql/mysql.pro

做如下修改

注释 #QMAKE_USE += mysql

mysql.pro 增加
DESTDIR = ../mysql/target 
INCLUDEPATH += /usr/include/mysql
LIBS += -L/usr/lib/mysql/ -lmysqlclient

注释 #include($shadowed($PWD)/qtsqldrivers-config.pri) 

增加 include($shadowed($PWD)/configure.pri) 

使用命令行编译

cd /opt/Qt/5.15.2/Src/qtbase/src/plugins/sqldrivers/mysql/m
/opt/Qt/5.15.2/gcc_64/bin/qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/x86_64-linux-gnu/ -lmysqlclient" mysql.pro
make

生成的mysql库和目录

/opt/Qt/5.15.2/Src/qtbase/src/plugins/sqldrivers/plugins/sqldrivers

上门生成的库拷贝到如下目录

opt/Qt/5.15.2/gcc_64/plugins/sqldrivers

编写测试代码，看到驱动加载成功。