QSqlDatabase: QMYSQL3 driver not loaded?

[SGaist]

Hi,

Do you have the MySQL client library installed ?

[jdent]

Well, I see the files libqsqlmysql.dylib and libqsqlmysql_debug.dylib in the folder ~/Qt5.5.1/5.5/clang_64/plugins/sqldrivers so I guess it is installed??

[SGaist]

No, those are the Qt plugins. You need to verify that your OS has the MySQL client libraries installed.

[jdent]

Well I can run Mysql workbench correctly... does not that mean the client tools are installed?

[SGaist]

No, it does not. Are you running OS X ?

[jdent]

YES OS X 10.11.3

[SGaist]

Then unless you installed it using brew/macports or the official MySQL package. You won't have the client library.

[jdent]

how can I ensure that I have the client libraries?

[jdent]

Hi,

I apologise for making a question that probably should be answered by MySQL web site but I have not found any answer .. maybe someone that has a lot of experience with MySql can find it very easy to direct my attention to where I can figure out if the client library is available. Does it need to be in a PATH or another environment variable? Do I place that in bash_profile or bashrc?

I downloaded the mysql-connector-c-6.1.6-osx10.8-x86_64 source and it has the following libraries in the lib subdir:

libmysqlclient.a
libmysqlclient.dylib
libmysqlclient.18.dylib
libmysqlclient_r.a
libmysqlclient_r.dylib
libmysqlclient_r.18.dylib

How do I put them so Qt Creator will find them? These ARE the client libraries right?

Thanks again!!
Juan

[SGaist]

Yes, these are the client libraries.

Now run otool -L path/to/qsqlmysql.dylib. You will get the list of dependencies of the plugin with an entry concerning the MySQL client library. You will have to run install_name_tool -change current/path/to/client_library your/path/to/client/library qsqlmysql.dylib

[jdent]

@SGaist Your help, once again!!! I am deeply grateful...
Problem solved!!

Juan