Error QMYSQL Plugin on Windows

jsulm

@Stelian It should be in c:\Qt\Tools\mingw730_64\bin

Stelian

@jsulm I've run the full path to mingw32-make c:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers>c:\Qt\Qt5.12.1\Tools\mingw730_64\bin\mingw32-make

cd sqlite\ && ( if not exist Makefile C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -o Makefile C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && c:/Qt/Qt5.12.1/Tools/mingw730_64/bin/mingw32-make -f Makefile
mingw32-make[1]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
c:/Qt/Qt5.12.1/Tools/mingw730_64/bin/mingw32-make -f Makefile.Release all
mingw32-make[2]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
g++ -c -fno-keep-inline-dllexport -O2 -std=c++1z -fno-exceptions -Wall -W -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1\QtCore -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\mkspecs\win32-g++  -o .obj\release\qsql_sqlite.o qsql_sqlite.cpp
g++: error: CreateProcess: No such file or directory
mingw32-make[2]: *** [Makefile.Release:377: .obj/release/qsql_sqlite.o] Error 1
mingw32-make[2]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make[1]: *** [Makefile:42: release-all] Error 2
mingw32-make[1]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make: *** [Makefile:43: sub-sqlite-make_first] Error 2

Stelian

Meanwhile, I added c:\Qt\Qt5.12.1\Tools\mingw730_64\bin\mingw32-make in PATH environment variable in the System Properties and restart the computer and I've run again

c:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers>C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake -- MYSQL_INCDIR="C:/Program Files/MySQL/MySQL Server 8.0/include" MYSQL_LIBDIR="C:Program Files/MYSQL/MySQL Server 8.0/lib"

c:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers>c:\Qt\Qt5.12.1\Tools\mingw730_64\bin\mingw32-make

and I get ...

cd sqlite\ && ( if not exist Makefile C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -o Makefile C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && c:/Qt/Qt5.12.1/Tools/mingw730_64/bin/mingw32-make -f Makefile
mingw32-make[1]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
c:/Qt/Qt5.12.1/Tools/mingw730_64/bin/mingw32-make -f Makefile.Release all
mingw32-make[2]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
g++ -c -fno-keep-inline-dllexport -O2 -std=c++1z -fno-exceptions -Wall -W -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1\QtCore -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\mkspecs\win32-g++  -o .obj\release\qsql_sqlite.o qsql_sqlite.cpp
g++ -fno-keep-inline-dllexport -O2 -std=c++1z -fno-exceptions -Wall -W -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -dM -E -o .moc\release\moc_predefs.h C:\Qt\Qt5.12.1\5.12.1\mingw73_64\mkspecs\features\data\dummy.cpp
C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB --include C:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite/.moc/release/moc_predefs.h -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/mkspecs/win32-g++ -IC:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/Qt5.12.1/Sources/qtbase/src/3rdparty/sqlite -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtSql/5.12.1 -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtSql/5.12.1/QtSql -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtCore/5.12.1 -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtCore/5.12.1/QtCore -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtSql -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtCore -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include/c++ -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include/c++/x86_64-w64-mingw32 -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include/c++/backward -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include-fixed -IC:/Qt/Qt5.12.1/Tools/mingw730_64/x86_64-w64-mingw32/include smain.cpp -o .moc\release\smain.moc
g++ -c -fno-keep-inline-dllexport -O2 -std=c++1z -fno-exceptions -Wall -W -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1\QtCore -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\mkspecs\win32-g++  -o .obj\release\smain.o smain.cpp
gcc -c -fno-keep-inline-dllexport -O2 -std=gnu11 -fno-exceptions -Wall -W -Wextra -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1\QtCore -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\mkspecs\win32-g++  -o .obj\release\sqlite3.o C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c: In function 'sqlite3ThreadJoin':
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c:29362:8: warning: variable 'bRc' set but not used [-Wunused-but-set-variable]
   BOOL bRc;
        ^~~
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c: In function 'winUnfetch':
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c:44948:45: warning: unused parameter 'iOff' [-Wunused-parameter]
 static int winUnfetch(sqlite3_file *fd, i64 iOff, void *p){
                                             ^~~~
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c: In function 'sqlite3_db_status':
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c:20744:10: warning: this statement may fall through [-Wimplicit-fallthrough=]
       op = SQLITE_DBSTATUS_CACHE_WRITE+1;
       ~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c:20746:5: note: here
     case SQLITE_DBSTATUS_CACHE_HIT:
     ^~~~
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c: In function 'sqlite3_str_vappendf':
C:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite\sqlite3.c:27452:19: warning: this statement may fall through [-Wimplicit-fallthrough=]
         flag_long = sizeof(char*)==sizeof(i64) ? 2 :
         ~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                      sizeof(char*)==sizeof(long int) ? 1 : 0;
...
...
...
C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB --include C:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite/.moc/debug/moc_predefs.h -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/mkspecs/win32-g++ -IC:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/Qt5.12.1/Sources/qtbase/src/3rdparty/sqlite -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtSql/5.12.1 -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtSql/5.12.1/QtSql -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtCore/5.12.1 -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtCore/5.12.1/QtCore -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtSql -IC:/Qt/Qt5.12.1/5.12.1/mingw73_64/include/QtCore -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include/c++ -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include/c++/x86_64-w64-mingw32 -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include/c++/backward -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include -IC:/Qt/Qt5.12.1/Tools/mingw730_64/lib/gcc/x86_64-w64-mingw32/7.3.0/include-fixed -IC:/Qt/Qt5.12.1/Tools/mingw730_64/x86_64-w64-mingw32/include qsql_sqlite_p.h -o .moc\debug\moc_qsql_sqlite_p.cpp
g++ -c -fno-keep-inline-dllexport -g -Og -std=c++1z -fno-exceptions -Wall -W -Wextra -Wvla -Wdate-time -Wshift-overflow=2 -Wduplicated-cond -Wno-stringop-overflow -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -IC:\Qt\Qt5.12.1\Sources\qtbase\src\3rdparty\sqlite -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql\5.12.1\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1 -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore\5.12.1\QtCore -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtSql -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\include\QtCore -I.moc\debug -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\Qt5.12.1\5.12.1\mingw73_64\mkspecs\win32-g++  -o .obj\debug\moc_qsql_sqlite_p.o .moc\debug\moc_qsql_sqlite_p.cpp
windres -i qsqlited_resource.rc -o .obj\debug\qsqlited_resource_res.o --include-dir=. -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -DWINVER=0x0601 -D_WIN32_WINNT=0x0601 -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB
g++ -shared -Wl,-subsystem,windows -Wl,--out-implib,C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\plugins\sqldrivers\libqsqlited.a -o ..\plugins\sqldrivers\qsqlited.dll .obj/debug/qsql_sqlite.o .obj/debug/smain.o .obj/debug/sqlite3.o .obj/debug/moc_qsql_sqlite_p.o  -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.6.11-winx64\lib -LC:\Utils\postgresql\pgsql\lib -LC:\Qt\Qt5.12.1\5.12.1\mingw73_64\lib C:\Qt\Qt5.12.1\5.12.1\mingw73_64\lib\libQt5Sqld.a C:\Qt\Qt5.12.1\5.12.1\mingw73_64\lib\libQt5Cored.a .obj\debug\qsqlited_resource_res.o
mingw32-make[2]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make[1]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'

Stelian

When I've run a simple program

#include <QCoreApplication>
#include <QtSql>
#include <QSqlDatabase>
#include <QtDebug>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);

    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setUserName("root");
    db.setPassword("DSa81&l12&z26");
    db.setDatabaseName("Employee_management");

    if (db.open())
    {
        qDebug() << "Database connected successfuly!";
    }
    else
    {
        qDebug() << "Database is not connected!";
    }

    return a.exec();
}

I receive the message "Database is not connected!", which means there are still some blurring about the QMYSQL driver.

SGaist

Did you call mingw32-make install after the build succeeded ?

Stelian

Yes, and I received the next message

cd odbc\ && ( if not exist Makefile C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -o Makefile C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\odbc\odbc.pro ) && mingw32-make -f Makefile install
mingw32-make[1]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make -f Makefile.Release install
mingw32-make[2]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/odbc'
copy /y ..\plugins\sqldrivers\qsqlodbc.dll C:\Qt\Qt5.12.1\5.12.1\mingw73_64\plugins\sqldrivers\qsqlodbc.dll
        1 file(s) copied.
C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -install qinstall C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake C:\Qt\Qt5.12.1\5.12.1\mingw73_64\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake
mingw32-make[2]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make -f Makefile.Debug install
mingw32-make[2]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/odbc'
copy /y ..\plugins\sqldrivers\qsqlodbcd.dll C:\Qt\Qt5.12.1\5.12.1\mingw73_64\plugins\sqldrivers\qsqlodbcd.dll
        1 file(s) copied.
C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -install qinstall C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake C:\Qt\Qt5.12.1\5.12.1\mingw73_64\lib\cmake\Qt5Sql\Qt5Sql_QODBCDriverPlugin.cmake
mingw32-make[2]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/odbc'
mingw32-make[1]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/odbc'
cd sqlite\ && ( if not exist Makefile C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -o Makefile C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && mingw32-make -f Makefile install
mingw32-make[1]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make -f Makefile.Release install
mingw32-make[2]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
copy /y ..\plugins\sqldrivers\qsqlite.dll C:\Qt\Qt5.12.1\5.12.1\mingw73_64\plugins\sqldrivers\qsqlite.dll
        1 file(s) copied.
C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -install qinstall C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Qt\Qt5.12.1\5.12.1\mingw73_64\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
mingw32-make[2]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make -f Makefile.Debug install
mingw32-make[2]: Entering directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
copy /y ..\plugins\sqldrivers\qsqlited.dll C:\Qt\Qt5.12.1\5.12.1\mingw73_64\plugins\sqldrivers\qsqlited.dll
        1 file(s) copied.
C:\Qt\Qt5.12.1\5.12.1\mingw73_64\bin\qmake.exe -install qinstall C:\Qt\Qt5.12.1\Sources\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Qt\Qt5.12.1\5.12.1\mingw73_64\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
mingw32-make[2]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'
mingw32-make[1]: Leaving directory 'c:/Qt/Qt5.12.1/Sources/qtbase/src/plugins/sqldrivers/sqlite'

Part of this message is in my previous post

Stelian

When I run the code

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
Database is Not Connected!

SGaist

In Qt Creator's Run part of the Project panel, did you add the path to the MySQL dlls in the PATH environment variable ?

Stelian

@SGaist Let me understand.
First of all, do you mean I have to add that path "C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\lib" or this path "C:\Program Files\MySQL\MySQL Server 8.0\lib"
Second of all, where do I have to add ? (see picture1 and picture2) ?

jsulm

@Stelian As @SGaist wrote: in QtCreator Run settings.
I think you need the MySQL connector libs (but you can simply put both).

Stelian

@jsulm Where do I have to add in the first picture or second ?

jsulm

@Stelian In the second of course as it is showing exactly what was suggested: Run settings in QtCreator.

Stelian

@jsulm I,ve added both C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\lib" and this path "C:\Program Files\MySQL\MySQL Server 8.0\lib in Run Settings -> Run Environment -> Path, then restart Qt and run the code, Not connected.

SGaist

Then again, start your application with the QT_DEBUG_PLUGINS environment variable to see what is happening.

Stelian

@SGaist

QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlite.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlite.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QSQLITE"
        ]
    },
    "archreq": 0,
    "className": "QSQLiteDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlite.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlited.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlited.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QSQLITE"
        ]
    },
    "archreq": 1,
    "className": "QSQLiteDriverPlugin",
    "debug": true,
    "version": 330752
}


Got keys from plugin meta data ("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysql.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysql.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QMYSQL3",
            "QMYSQL"
        ]
    },
    "archreq": 0,
    "className": "QMYSQLDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysqld.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysqld.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QMYSQL3",
            "QMYSQL"
        ]
    },
    "archreq": 1,
    "className": "QMYSQLDriverPlugin",
    "debug": true,
    "version": 330752
}


Got keys from plugin meta data ("QMYSQL3", "QMYSQL")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbc.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbc.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QODBC3",
            "QODBC"
        ]
    },
    "archreq": 0,
    "className": "QODBCDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbc.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbcd.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbcd.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QODBC3",
            "QODBC"
        ]
    },
    "archreq": 1,
    "className": "QODBCDriverPlugin",
    "debug": true,
    "version": 330752
}


Got keys from plugin meta data ("QODBC3", "QODBC")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsql.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsql.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QPSQL7",
            "QPSQL"
        ]
    },
    "archreq": 0,
    "className": "QPSQLDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsqld.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsqld.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QPSQL7",
            "QPSQL"
        ]
    },
    "archreq": 1,
    "className": "QPSQLDriverPlugin",
    "debug": true,
    "version": 330752
}


Got keys from plugin meta data ("QPSQL7", "QPSQL")
QFactoryLoader::QFactoryLoader() checking directory path "E:/Qt Creator/build-sql_console_test-Desktop_Qt_5_12_1_MinGW_64_bit-Debug/debug/sqldrivers" ...
Cannot load library C:\Qt\Qt5.12.1\5.12.1\mingw73_64\plugins\sqldrivers\qsqlmysqld.dll: The specified module could not be found.
QLibraryPrivate::loadPlugin failed on "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysqld.dll" : "Cannot load library C:\\Qt\\Qt5.12.1\\5.12.1\\mingw73_64\\plugins\\sqldrivers\\qsqlmysqld.dll: The specified module could not be found."
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
Database is Not Connected!

SGaist

Looks like you only built the plugin for release and not for debug and you are running a debug build of your application.

Stelian

@SGaist I do not know if I built the plugin for release and not for debug, but if you say that I did, ok, you are the champion.
Tell me what I have to do next.

Stelian

@SGaist Believe me, I don't know how to build a plugin in release mode or in debug mode, to my shame.
If I did that, I did it unconsciously.

SGaist

Add -debug to the qmake call

Stelian

@SGaist I've called the qmake in debug mode, run the code and again Database is Not Connected!
Then again, I have start the application with the QT_DEBUG_PLUGINS environment variable and I get the next message

QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlite.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlite.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QSQLITE"
        ]
    },
    "archreq": 0,
    "className": "QSQLiteDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlite.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlited.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlited.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QSQLITE"
        ]
    },
    "archreq": 1,
    "className": "QSQLiteDriverPlugin",
    "debug": true,
    "version": 330752
}


Got keys from plugin meta data ("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysql.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysql.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QMYSQL3",
            "QMYSQL"
        ]
    },
    "archreq": 0,
    "className": "QMYSQLDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysqld.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysqld.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QMYSQL3",
            "QMYSQL"
        ]
    },
    "archreq": 1,
    "className": "QMYSQLDriverPlugin",
    "debug": true,
    "version": 330752
}


Got keys from plugin meta data ("QMYSQL3", "QMYSQL")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbc.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbc.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QODBC3",
            "QODBC"
        ]
    },
    "archreq": 0,
    "className": "QODBCDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbc.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbcd.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlodbcd.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QODBC3",
            "QODBC"
        ]
    },
    "archreq": 1,
    "className": "QODBCDriverPlugin",
    "debug": true,
    "version": 330752
}


Got keys from plugin meta data ("QODBC3", "QODBC")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsql.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsql.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QPSQL7",
            "QPSQL"
        ]
    },
    "archreq": 0,
    "className": "QPSQLDriverPlugin",
    "debug": false,
    "version": 330752
}


"The plugin 'C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsqld.dll"
Found metadata in lib C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlpsqld.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QPSQL7",
            "QPSQL"
        ]
    },
    "archreq": 1,
    "className": "QPSQLDriverPlugin",
    "debug": true,
    "version": 330752
}

Got keys from plugin meta data ("QPSQL7", "QPSQL")
QFactoryLoader::QFactoryLoader() checking directory path "E:/Qt Creator/build-sql_console_test-Desktop_Qt_5_12_1_MinGW_64_bit-Debug/debug/sqldrivers" ...
Cannot load library C:\Qt\Qt5.12.1\5.12.1\mingw73_64\plugins\sqldrivers\qsqlmysqld.dll: The specified module could not be found.
QLibraryPrivate::loadPlugin failed on "C:/Qt/Qt5.12.1/5.12.1/mingw73_64/plugins/sqldrivers/qsqlmysqld.dll" : "Cannot load library C:\\Qt\\Qt5.12.1\\5.12.1\\mingw73_64\\plugins\\sqldrivers\\qsqlmysqld.dll: The specified module could not be found."
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
Database is Not Connected!