Mysql can't connect on MacBook
-
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 ,..@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-itLook through the end of the output for what the issue is.
-
@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-itLook through the end of the output for what the issue is.
-
Hi,
@Eternus said in Mysql can't connect on MacBook:
how can I go in shell ?
Use the Terminal application.
-
Hi,
@Eternus said in Mysql can't connect on MacBook:
how can I go in shell ?
Use the Terminal application.
-
What exactly are you writing in your terminal ?
-
@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 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.
-
Explain what ?
-
@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 : qt5and 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 -
@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 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 said in Mysql can't connect on MacBook:
@SGaist ??if I install Mysql on vps should be work ?
What do you mean ?
-
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.
-
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.
@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 QPSQL72020-08-21 23:09:50.887121+0200 Test[946:23566] QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.
-
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 ?
-
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 ?
