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.
<code>#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);
qDebug() << "Hello4";
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();
}
</code>
<code>#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);
qDebug() << "Hello4";
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();
}
</code>
#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);
qDebug() << "Hello4";
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
New contributor
aditya kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.