mysql - Qt 库 'mysql' 未定义

Question

当我运行这段代码时，Qt 与 MySql 的连接出现问题

    QSqlDatabase DBObject = QSqlDatabase::addDatabase("QMYSQL");
    DBObject.setHostName("localhost");
    DBObject.setDatabaseName("SingleDB");
    DBObject.setUserName("root");
    DBObject.setPassword("abc123");
    bool ok = DBObject.open();

我得到了这个... QSqlDatabase:未加载 QMYSQL 驱动程序

我也这样做过:

sudo apt-get install libmysqlclient

和

/home/wrm/Qt/5.12.3/gcc_64/bin/qmake "INCLUDEPATH+=/usr/local/include" "LIBS+=-L/usr/local/lib -lmysqlclient_r" mysql.pro

这里我有这个错误:项目错误:库“mysql”未定义

有什么想法吗？

Answer 1

也许你需要安装mysql-devel。

根据 Qt 文档 QMYSQL for MySQL 4 and higher :

How to Build the QMYSQL Plugin on Unix and macOS

You need the MySQL header files, as well as the shared library libmysqlclient.so. Depending on your Linux distribution, you may need to install a package which is usually called "mysql-devel".