QSqlDatabase: QMYSQL driver not loaded and not available

[mturner]

Hello to all, I have the following error :

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

The problem is that I can find nowhere on the internet how to solve this because there isn't QMYSQL in the available drivers already. I've downloaded MySql using brew, never had a pb but the dylib file isn't even in the plugin folder of Qt.

Could someone help me? Spent so much time on this already.

[SGaist]

Hi and welcome to devnet,

Depending on the version of Qt you have the plugin is not provided pre-built anymore because of a change in the license of MySQL, so you have to build it yourself.

[Bonnie]

Hi, for recent Qt versions, the mysql plugin is no longer provided due to license problem of libmysql.
You will need to build your own. Please refer to the doc:
https://doc.qt.io/qt-5/sql-driver.html#how-to-build-the-qmysql-plugin-on-unix-and-macos
Or you can use older versions of Qt.

[mturner]

Hello, thank you for the quick response!!
So I ran the following code :

qmake -- MYSQL_PREFIX=/usr/local/Cellar/mysql/8.0.19_1/include

And I get the "documentation" of how to use qmake so I'm guessing I'm doing something wrong...

[Bonnie]

@mturner First you need to cd to [QtDir]/Src/qtbase/src/plugins/sqldrivers which has .pro file and source code files in it.
It is not the sqldrivers folder with other dylib files.

[mturner]

Thank you a lot !!! I was in the wrong plugin/sqldrivers directory. Thank you to all of you!