1

I'm already build and install the MySql drive like here.. But still I got the error message QMYSQL driver not loaded. Now it;s say MySql as a available driver. I'm using 64bit windows, Qt creator version 32-bit, mingw81_64 and MySql 64 bit Error is,

" QMYSQL driver not loaded. available drivers: QSQLITE QMARIADB QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7"

Improve this question
1
  • See that space at the beginning. I am suspicious. If you load the driver with a string check for a leading space. Commented May 26, 2020 at 18:40

2 Answers 2

Reset to default
0

This question is already answered here. Enough details are provided there. In brief:

  1. Download proper libmysql.lib based on your Qt creator version (32-bit?)
  2. Put that dll in your build directory (to see your project's build directory, click the "Projects" button on the left menu bar on Qt creator and see the "Build directory")
  3. Build and run

Edit 1:

One more thing: when you download different versions of libmysql.dll, do as follows:

  • Right click on your application project and select "Add Library"
  • A dialog opens. Select "External library" radio button and click "Next"
  • For the "Library file", brows for your libmysql.lib and select it
  • In the "Platform" section, select the proper platform (windows, linux, ...)
  • If you are a windows user, make sure to check the "Library inside "debug" or "release" subfolder" checkbox
  • Click next

This is the most reliable way to add a library to your project. Hope this helps.

Improve this answer
Sign up to request clarification or add additional context in comments.

9 Comments

I'm using 64bit windows, Qt creator version 32-bit, mingw81_64 and MySql 64 bit. Is there any problem?
No, there is no problem. Did you follow the above steps? I had the same problem and finally solved by testing different versions of libmysql.dll. I wrote you some other things in my answer. Please see "Edit 1".
Thaanks. I'll try it
Is that libmysql.lib or libmysql.dll ?
Sorry, you're right. You have to select libmysql.lib.
|
0

Probably you don't have the libmysql.dll (or libmariadb.dll) in your path. The mechanism is that the MySQL database plugin dll is dynamically loaded runtime, and even if the database plugin itself is present (therefore listed as available), it might fail to load if the libmysql.dll (or libmariadb.dll) is not found.

Improve this answer

1 Comment

Thank you for answer. Can you please explain What is the path?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.