Mysql can't connect on MacBook

Eternus

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7
I have this error I find solution on forum but that wasn't on MacBook someone know how can I fix this ?

void MainWindow::on_pushButton_login_clicked()
{

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("127.0.0.1");
db.setUserName("root");
db.setPassword("aaaaa");
db.setDatabaseName("QTUSERS");

if(db.open()) {
    QMessageBox::information(this,"Connection", "Database connectet");
} else {
    QMessageBox::information(this,"Connection", "Database not found");
}

}

in pro I have sql..
I have downloaded mysql community ,..

JonB

@Eternus
You have to start by setting environment variable in a shell/terminal and then invoking your application from there, to get diagnostic information. I don't know how exactly you do that on Mac, but from Linux:

export QT_DEBUG_PLUGINS=1
path-to-your-executable-to-run-it

Look through the end of the output for what the issue is.

Eternus

how can I go in shell ?

Eternus

@JonB if I install mysql on VPS it will be work???

SGaist

Hi,

@Eternus said in Mysql can't connect on MacBook:

how can I go in shell ?

Use the Terminal application.

Eternus

@SGaist

yes i know but what a command ?
if i put in these 2 line 2 line dont work

SGaist

What exactly are you writing in your terminal ?

Eternus

@SGaist

export QT_DEBUG_PLUGINS=1
path-to-your-executable-to-run-it

this first reply

SGaist

@Eternus said in Mysql can't connect on MacBook:

path-to-your-executable-to-run-it

You do realize that this is a placeholder text that you have to replace with the actual path to the executable you are trying to run ?

On the other side, you can also define QT_DEBUG_PLUGINS environment variable in the Run part of the Project panel and start your application as usual.

Eternus

@SGaist

please can u explain me ? i am beginner and starting with qt and c++ soo i dont know much ..

SGaist

Explain what ?

Eternus

@SGaist
how too add qt_debug_plugins...

Eternus

@SGaist I find this https://forum.qt.io/topic/106565/mysql-qt-create-plugin-mysql-for-qt-on-mac

can't find thes gunzip qt-everywhere-opensource-src-%VERSION%.tar.gz
I have only this : qt5

and then I try this https://doc.qt.io/qt-5/macos-building.html
I can't find thes gunzip qt-everywhere-opensource-src-%VERSION%.tar.gz
I have only this : qt5

SGaist

@Eternus said in Mysql can't connect on MacBook:

@SGaist
how too add qt_debug_plugins...

You do realize that is indicated precisely where you should do it in Qt Creator ?

Eternus

@SGaist ??if I install Mysql on vps should be work ?

SGaist

@Eternus said in Mysql can't connect on MacBook:

@SGaist ??if I install Mysql on vps should be work ?

What do you mean ?

Eternus

sorry nothing I mean how can I fix this problem ? I think add qt_debug_plugins... this isn't solution ...

SGaist

I never said it would be the solution, the goal is to gather information about why the plugin is not loading in order to fix it. And be careful, the name of the variable is all in upper case.

Eternus

@SGaist
if I start debugging I have same this :
23:08:46: Debugging starts
2020-08-21 23:08:51.949814+0200 Test[946:23566] QPixmap::scaled: Pixmap is a null pixmap
2020-08-21 23:08:53.840401+0200 Test[946:23566] QSqlDatabase: QMYSQL driver not loaded
2020-08-21 23:08:53.840464+0200 Test[946:23566] QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

2020-08-21 23:09:50.887121+0200 Test[946:23566] QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.

SGaist

The application output shows one thing: you are misusing the QSqlDatabase class. It also does not show the plugin loading debug data.

Did you add the QT_DEBUG_PLUGINS variable in Qt Creator like I suggested ? If so, did you set it to 1 ?