mysql - Why QMYSQL driver not loaded in QT5.2?

Question

My program is write with QT5.2 and use mysql. I heared that QT5.2 contains MYSQL driver already. However, when I compile and run my program, it is compiled successfully but runned failed with error:

   QSqlDatabase: QMYSQL driver not loaded
   QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7

My programe is like this:

     QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL");
     db.setHostName("localhost");
     db.setDatabaseName("tradingsystem");
     db.setUserName("root");
     db.setPassword("");
     if(!db.open())
     {
          //.....;
     }

And in .pro I add this:

    QT += sql

Mysql is provided by XAMPP.My OS is win7-x64-sp1-ultimate, and XAMPP Version 1.8.2.System Path is as follow:

    C:Program Files (x86)SepanderSoft;
    C:Program Files (x86)InteliCLS Client;
    C:Program FilesInteliCLS Client;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;
    C:Program FilesIntelIntel(R) Management Engine ComponentsDAL;
    C:Program FilesIntelIntel(R) Management Engine ComponentsIPT;
    C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDAL;
    C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPT;
    C:Program FilesIntelWiFiin;
    C:Program FilesCommon FilesIntelWirelessCommon;
    C:Program Files (x86)IntelOpenCL SDK3.0inx86;
    C:Program Files (x86)IntelOpenCL SDK3.0inx64;
    C:Program FilesMicrosoftWeb Platform Installer;
    C:Program Files (x86)Microsoft ASP.NETASP.NET Web Pagesv1.0;
    C:Program Files (x86)Windows Kits8.0Windows Performance Toolkit;
    C:Program FilesMicrosoft SQL Server110ToolsBinn;
    D:SoftwareMySQLMySQL Enterprise Backup 3.8.2

XAMPP location is :

    D:XAMPP

QT location is:

    D:SoftwareQt

I have installed mysql server-5.6-64bit in D:SoftwareMySQL, and when it conflicted with mysql in XAMPP, I uninstalled mysql server-5.6-64bit.

Answer 1

I met with the same error and fixed it successfully by copying file

C:Program Files (x86)MySQLMySQL Connector.C 6.1liblibmysql.dll

into to

C:QtQt5.3.15.3mingw482_32in

Youtube link