qt creator连接mysql,如何使用QT Creator修复连接到MYSQL的问题

I an learning QT creator. I found a sample program to connect to MYSQL. When I run it, I get these errors

QSqlDatabase: QMYSQL driver not loaded

QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7

I have googled this for hours. Many suggest compiling the MYSQL plugin from scratch. I found the instructions didn't work. The path names were incorrect.

I am using Ubuntu 14.04 LTS. MYSQL version is 5.5.46-0ubuntu0.14.04.2.

QT creator version is 5.5.1. QT version 5.5.5

Here is the same qt project file

----------------------------------------------------------QT += core

QT -= gui

QT += webkit webkitwidgets

QT += sql

TARGET = TestMySqlExample

CONFIG += console

CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp

Here is the sample code

--------------------------------------------------------------------

#include#include#include#include#include#include#include

bool createConnection();

int main(int argc, char *argv[])

{

QApplication app(argc, argv);

if (!createConnection()){

qDebug() << "Not connected!";

return 1;

}

else{

qDebug() << "Connected!";

QSqlQuery query;

query.exec("SELECT Name FROM student");

while (query.next()) {

QString name = query.value(0).toString();

qDebug() <

}

return 0;

}

return app.exec();

}

bool createConnection(){

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");

db.setHostName("localhost");

db.setDatabaseName("mydb");

db.setUserName("root");

db.setPassword("moonpie");

if (!db.open()) {

qDebug() << "Database error occurred";

return false;

}

return true;

}

解决方案See http://doc.qt.io/qt-5/qsqldatabase.html#QSqlDatabase-2[^] for correct instantiation of the QSqlDatabase class.