How to Connect to MySQL database

[johnL]

I am trying to connect to a MySQL database but QT doesn't load the MySQL Driver.
Both QSqlDatabase::drivers().contains("QMYSQL") and QSqlDatabase::isDriverAvailable("QMYSQL") return true but

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL") fails with error message

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7

The API documentation for addDatabase() implies that the addDatabase("DRIVER") call will open a connection and therefore should load the necessary driver.
Certainly QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE") succesfully opens a connection to SQLITE without any supplementary calls to "Load" a driver.

Some someone please explain how to get a connection to MySQL? or Load the MySQL driver?

Note: MySQL Server version: 5.5.37-0ubuntu0.14.04.1 is installed and running. Database can be accessed from Terminal so problem is not on MySQL side.

Regards
johnL

[anda_skoa]

Try setting QT_DEBUG_PLUGINS=1 in the environment from where you run the program.

Maybe that gives more hints on what is going wrong when Qt attempts to load the plugin.

Cheers,
_

[folibis]

Probably libmysqlclient.dll/so is not accesible by the plugin.

[adutzu89]

Check this thread.

[johnL]

OK - I've set QT_DEBUG_PLUGINS=1 in /etc/environment
Now what - does this initiate logging? If so, what file in what location?

I've spent most of today investigating this and implementing various "solutions" from other trails in the forum - installing mysql-connector, adding symlinks to libmysqlconn, copying libmysqlclient_r.so etc - to no avail

A log printout may well identify the problem.

Regards

[adutzu89]

Have you installed libmysqlclient-dev?

[anda_skoa]

Now what - does this initiate logging? If so, what file in what location?

Not to a file, to the applications STDERR if I remember correctly.

Cheers,
_

[stoyanps]

One possible problem can be that the version of installed MySQL is 64-bit, while the version of Qt (and QMYSQL plugin) is 32-bit.