PDA

View Full Version : MySQL driver building error



Hesh
9th November 2017, 06:58
My resources:

OS windows 10 Pro 64 bit
Qt :Qt Creator 4.4.1 Based on Qt 5.9.2 (MSVC 2015, 32 bit)
MinGW 5.3.0.32 bit


First when I try to got to cd %QTDIR%/src/qtbase/src/plugins/sqldrivers/mysql in min gw

I get this The system cannot find the path specified.

Then I hive my exat path (cd C:\Qt\Qt5.9.2\5.9.2\Src\qtbase\src\plugins\sqldriv ers\mysql) and MinGW goes to the folder


Then we are supposed to give include and bin paths of the mysql-connector-c-6.1.11-win32 file in the following line.

qmake "CONFIG+=release" "INCLUDEPATH+=C:\Program Files (x86)\MySQL\mysql-connector-c-6.1.11-win32\include" "C:\Program Files (x86)\MySQL\mysql-connector-c-6.1.11-win32\lib" "LIBS+=-llibmysql" mysql.pro

Then it gives this giant error

Cannot read C:/Program Files (x86)/MySQL/mysql-connector-c-6.1.11-win32/lib: Access is denied.
Error processing project file: C:\Program Files (x86)\MySQL\mysql-connector-c-6.1.11-win32\lib
Cannot find file: mysql.pro.


Please help !!!!

RD_Square
23rd November 2017, 06:59
I think error can removed by using

CONFIG += release

QTPLUGIN: QSQLMYSQLS

INCLUDEPATH += C:\Program Files (x86)\MySQL\mysql-connector-c-6.1.11-win32\include

win32: LIBS += C:\Program Files (x86)\MySQL\mysql-connector-c-6.1.11-win32\include\lib\ -llibmysql

in your .pro file

if not working then try by adding

win32:CONFIG(release, debug|release): LIBS += C:\Program Files (x86)\MySQL\mysql-connector-c-6.1.11-win32\include\lib\ -llibmysql
else:win32:CONFIG(debug, debug|release): LIBS += C:\Program Files (x86)\MySQL\mysql-connector-c-6.1.11-win32\include\lib\ -llibmysqld