SSL connection error: unknown error number QMYSQL: Unable to connect

Aditya20

I am new to QT development. I am trying to connect with mysql database from the qt application but getting ssl connection error. Below is the code snippet.

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

void connectToDatabase() {
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("aditya");
db.setUserName("root");
db.setPassword("aditya");
db.setPort(3306);

if (!db.open()) {
    qDebug() << "Error: connection with database fail:" << db.lastError().text();
} else {
    qDebug() << "Database: connection ok";
}

}

void executeQuery() {
QSqlQuery query;
if (query.exec("SELECT * FROM Test")) {
while (query.next()) {
QString name = query.value("name").toString();
qDebug() << "Name:" << name;
}
} else {
qDebug() << "Query failed:" << query.lastError().text();
}
}

int main(int argc, char *argv[]) {
QCoreApplication a(argc, argv);

connectToDatabase();
//executeQuery();

return a.exec();

}

Getting below error while running the program

Error: connection with database fail: "SSL connection error: unknown error number QMYSQL: Unable to connect"

Any leads will be appreciated.

Thanks

SGaist

Hi and welcome to devnet,

What kind of certificate are you using for that database ?
Which version of Qt are you using ?
On which OS ?
Which version of MySQL ?

Aditya20

@SGaist I do not have any certificate added as of now.
QT version: 6.5.6
OS: Windows
MySQL version: 8.0.36

Aditya20

@Aditya20 said in SSL connection error: unknown error number QMYSQL: Unable to connect:

6.5.6

6.5.3

Christian Ehrlicher

Disable ssl on your mysql server and/or try to disable them with the appropriate connect options (but might not work when the mysql server is configured to not allow unencrypted connections).

Aditya20

@Christian-Ehrlicher I have already disabled SSL on MySQL server

Aditya20

I am still facing same issue. Any help would be appreciated

JonB

@Aditya20
I don't know what it will tell us, but to start out can you connect successfully using, say, MySQL Workbench and mysqldump?

Christian Ehrlicher

@Aditya20 said in SSL connection error: unknown error number QMYSQL: Unable to connect:

I am still facing same issue. Any help would be appreciated

And you still did not played around with the corresponding connect options ... so no help from my side possible.

Aditya20

@SGaist Any updates from your end for the issue

SGaist

@Aditya20 did you do the checks suggested by @JonB ?
Are you sure about the port ?
Are you sure that connections to that port are allowed ?

Aditya20

@SGaist I was finally able to resolve the issue by using skip_ssl in my.ini file.