Problem with MySQL driver on mac

[kenchan]

@Albert-Huert said in Problem with MySQL drive on mac:

QSqlDatabase: QMYSQL driver not loaded

does your .pro file specify the library and the path to it correctly?

[SGaist]

Hi,

Start your application with the QT_DEBUG_PLUGINS environment variable set to 1. It will show you more information about what is happening with the MySQL plugin.

[Albert Huert]

@SGaist said in Problem with MySQL drive on mac:

Start your application with the QT_DEBUG_PLUGINS

Hi,
how I start application with the QT_DEBUG_PLUGINS?
thanks for your answer

[jsulm]

@Albert-Huert If you're using QtCreator go to the Run settings of your projects and add it in "Run Environment".

[Albert Huert]

@jsulm thank you very much for your help!!

[Albert Huert]

@SGaist Hi,
I get this output,

Got keys from plugin meta data ("QPSQL7", "QPSQL")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/eduardo/Desktop/build-prueba-Desktop_Qt_5_11_1_clang_64bit-Debug/prueba.app/Contents/MacOS/sqldrivers" ...
Cannot load library /Users/eduardo/Qt/5.11.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: (dlopen(/Users/eduardo/Qt/5.11.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib, 133): Library not loaded: /usr/local/mysql/lib/libmysqlclient.20.dylib
Referenced from: /Users/eduardo/Qt/5.11.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib
Reason: image not found)
QLibraryPrivate::loadPlugin failed on "/Users/eduardo/Qt/5.11.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib" : "Cannot load library /Users/eduardo/Qt/5.11.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: (dlopen(/Users/eduardo/Qt/5.11.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib, 133): Library not loaded: /usr/local/mysql/lib/libmysqlclient.20.dylib\n Referenced from: /Users/eduardo/Qt/5.11.1/clang_64/plugins/sqldrivers/libqsqlmysql.dylib\n Reason: image not found)"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7

I have seen that it is recommended to add DYLD_LIBRARY_PATH, but it appears as variable in "run environment".

[SGaist]

@Albert-Huert said in Problem with MySQL driver on mac:

I have seen that it is recommended to add DYLD_LIBRARY_PATH, but it appears as variable in "run environment".

That's correct.

Append :/usr/local/mysql/lib/ to it. The semicolon is the separation between paths just as in the PATH environment variable.

[Albert Huert]

@SGaist Solved with the instruction you gave me.
Thank you

[Albert Huert]

@kenchan Thank you very much for the help.

[SGaist]

Great !

Since you have it working now, please mark the thread as solved using the "Topic Tools" button so that other forum users may know a solution has been found :)