MariaDB

[transistor47]

Hello everybody,
I have downloaded MariaDB Connector C/C++ but does not work
Is there anybody or a tutorial to learn how install MariaDB connector?
I use Ubuntu 18.04 desktop
Thank you!

[fcarney]

Isn't MariaDB compatible with MySQLDB? Just use standard mysql Qt objects. Or do you need things that mariadb has the mysql does not?
https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/

[transistor47]

When I run my code appears:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7
Failed to connect.

My code is:

#include <QCoreApplication>
#include <QtSql>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QDebug>

*int main(int argc, char argv[])
{
QCoreApplication a(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("127.0.0.1");
db.setPort(3306);
db.setDatabaseName("test");
db.setUserName("usuario");
db.setPassword("usuario");
if (db.open())
{
qDebug() << "Connected!";
}
else
{
qDebug() << "Failed to connect.";
return 0;
}
return a.exec();
}

What connector do you recommend?

Thank you

[Christian Ehrlicher]

@transistor47 said in MariaDB:

QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

As you can see there is no QMYSQL driver available. You have to compile it by your own (or, if you use the Qt from your distribution, install the qmysql package)

[fcarney]

Hmmm... sorry, I made some assumptions:
https://doc.qt.io/qt-5/sql-driver.html

[transistor47]

**

• Thank you!!!**