Unsolved MySQL driver on Windows 10

[Infinity]

First of all I have to mention that I'm not very familiar with Windows, but I have to compile my application on Windows 10. For this I installed MySQL Server 8.0 and Qt 5.13.1. Now I would like to build the mysql driver for Qt.

Here is my mysql.pro:

TARGET = qsqlmysql

INCLUDEPATH += "C:/MySQL/MySQL Server 8.0/include"
LIBS += -L"C:/MySQL/MySQL Server 8.0/lib"
LIBS += -llibmysql

HEADERS += $$PWD/qsql_mysql_p.h
SOURCES += $$PWD/qsql_mysql.cpp $$PWD/main.cpp

QMAKE_USE += mysql

OTHER_FILES += mysql.json

PLUGIN_CLASS_NAME = QMYSQLDriverPlugin
include(../qsqldriverbase.pri)

When I run qmake I get the following error:

Project ERROR: Library 'mysql' is not defined.

Here is the listing of the MySQL direcoty:

07.09.2019  08:17    <DIR>          .
07.09.2019  08:17    <DIR>          ..
26.06.2019  21:19         7’101’952 http_auth_backend.dll
26.06.2019  21:19         7’071’744 http_auth_realm.dll
26.06.2019  21:19         7’353’344 http_server.dll
26.06.2019  21:19            19’968 keepalive.dll
26.06.2019  21:18         6’479’872 libmysql.dll
26.06.2019  21:18            29’188 libmysql.lib
07.09.2019  08:17    <DIR>          mecab
26.06.2019  21:20         7’892’992 metadata_cache.dll
26.06.2019  21:18        65’764’822 mysqlclient.lib
26.06.2019  21:18            44’750 mysqlrouter_http.lib
26.06.2019  21:19        22’951’984 mysqlrouter_lib.lib
26.06.2019  21:19            90’624 mysql_protocol.dll
07.09.2019  08:17    <DIR>          plugin
26.06.2019  21:20         7’111’680 rest_api.dll
26.06.2019  21:20         7’121’920 rest_metadata_cache.dll
26.06.2019  21:20         7’096’320 rest_router.dll
26.06.2019  21:20         7’140’864 rest_routing.dll
26.06.2019  21:20         7’461’376 routing.dll
              16 Datei(en),    160’733’400 Bytes
               4 Verzeichnis(se), 120’553’926’656 Bytes frei

c:\MySQL\MySQL Server 8.0\lib>

What am I doing wrong here?

[SGaist]

Hi,

Looks like you are not following the Qt SQL drivers documentation, are you ?

[Infinity]

I tried it, butthe directory C:/MYSQL/MySQL Server <version>/lib/opt does not exist on my Windows installation and I also got the message that %QTDIR%\qtbase\src\plugins\sqldrivers does not exist.

I have Qt installed here:
C:\Qt\5.13.1\Src\qtbase\src\plugins\sqldrivers/

and MySQL here:
C:\MySQL\MySQL Server 8.0\

The libmysql.dll is in this directory:
C:\MySQL\MySQL Server 8.0\lib\

but there is no:
C:\MySQL\MySQL Server 8.0\lib\opt

How would the qmake command line look like with this setup?

[SGaist]

You have to update the example given in the documentation to match what you have on your system.

[Jungkang65]

This post is deleted!