Connect to MYSQL failed in Qt

[Christian Ehrlicher]

@ELEMENTICY said in Connect to MYSQL failed in Qt:

And yea,i copy the mysql include and lib folder to the project folder

But you don't link against the mysql libs in your pro file.

What does not work with the QtSql plugin?

[ELEMENTICY]

@Christian-Ehrlicher i do,

win32:CONFIG(release, debug|release): LIBS += -L$$PWD/lib/libmysql
else:win32:CONFIG(debug, debug|release): LIBS += -L$$PWD/lib/libmysqld
else:unix: LIBS += -L$$PWD/lib/libmysql

And yea,use qt sql it just give like 11 error
And if i use official mysql mysql.h,it only give 2 error which is undefine

And yea,or i need to change my profile's lib code to this?

win32:CONFIG(release, debug|release): LIBS += -L$$PWD/lib/libmysql.lib
else:win32:CONFIG(debug, debug|release): LIBS += -L$$PWD/lib/libmysqld.lib
else:unix: LIBS += -L$$PWD/lib/libmysql.lib

[ELEMENTICY]

will it bcuz i use qt6+ so it doesnt work?(i mean qt sql)

[Christian Ehrlicher]

@ELEMENTICY said in Connect to MYSQL failed in Qt:

it doesnt work

This is no error description...

[ELEMENTICY]

@Christian-Ehrlicher bcuz it give too much error,i rather use official mysql header
Qt6 has alot of stuff doesnt exist.Like web browser
So i rather use the official mysql header and it give less error

These are the only error:
error: undefined reference to 'mysql_init'

error: undefined reference to 'mysql_real_connect'

error: linker command failed with exit code 1 (use -v to see invocation) clang++: error: linker command failed with exit code 1 (use -v to see invocation) make: *** [Makefile:73: libPos_x86_64.so] Error 1

Use Qt sql give like 11 error or more/less

[SGaist]

The SQL module is supported in Qt 6. However the MySQL plugin might not be provided because Oracle changed their licensing.

As for your build issue: -L is for giving path to search, it's -l for stating the name of the library.

[Christian Ehrlicher]

So the QtSql module has no errors - please stay specific!

else:unix: LIBS += -L$$PWD/lib/libmysql.lib

This is for sure not correct.

[ELEMENTICY]

@Christian-Ehrlicher but qtsql mysql plugin doesnt provided as @SGaist said it,i tried add it by following youtube tutorial,it still doesnt.Lemme try it again and send the error here

[ELEMENTICY]

@Christian-Ehrlicher

This is for sure not correct.

oh,how do i fix it?

[SGaist]

@ELEMENTICY said in Connect to MYSQL failed in Qt:

@Christian-Ehrlicher

This is for sure not correct.

oh,how do i fix it?

Re-read my previous answer.

[ELEMENTICY]

@SGaist so i have to make it

win32:CONFIG(release, debug|release): LIBS += -L$$PWD/lib/ -l libmysql
else:win32:CONFIG(debug, debug|release): LIBS += -L$$PWD/lib/ -l libmysqld
else:unix: LIBS += -L$$PWD/lib/ -l libmysql

?

[SGaist]

No space no "lib" prefix.

It's explained in the documentation

[ELEMENTICY]

@SGaist my current profile code:

win32:CONFIG(release, debug|release): LIBS += -L$$PWD/lib/ -llibmysql
else:win32:CONFIG(debug, debug|release): LIBS += -L$$PWD/lib/ -llibmysqld
else:unix: LIBS += -L$$PWD/lib/ -llibmysql

documentation:

LIBS += -L"3rdparty/CatWhisperer/lib" -lCatWhisperer

i got this error:
:-1: error: error: cannot find -llibmysql

proof that path exists:

[Christian Ehrlicher]

@ELEMENTICY said in Connect to MYSQL failed in Qt:

And yea,use qt sql it just give like 11 error

What does this mean?

[SGaist]

@ELEMENTICY did you read what I wrote ? No "lib" prefix.

[ELEMENTICY]

@SGaist
current code:

win32:CONFIG(release, debug|release): LIBS += -L$$PWD/lib/libmysql
else:win32:CONFIG(debug, debug|release): LIBS += -L$$PWD/lib/libmysqld
else:unix: LIBS += -L$$PWD/lib/libmysql

idk if i misunderstanded what u mean,but it still give error ;/
or u mean i have to remove that -L

[ELEMENTICY]

@SGaist and yea i dont know if its because im working on a android app,so it doesnt work

[SGaist]

@ELEMENTICY said in Connect to MYSQL failed in Qt:

@SGaist
current code:

win32:CONFIG(release, debug|release): LIBS += -L$$PWD/lib/libmysql
else:win32:CONFIG(debug, debug|release): LIBS += -L$$PWD/lib/libmysqld
else:unix: LIBS += -L$$PWD/lib/libmysql

idk if i misunderstanded what u mean,but it still give error ;/
or u mean i have to remove that -L

You have to understand what -L and -l each do. I have already explained that before. So please re-read the corresponding answers.

[SGaist]

@ELEMENTICY said in Connect to MYSQL failed in Qt:

@SGaist and yea i dont know if its because im working on a android app,so it doesnt work

Oracle does not provide pre-built binaries for Android.

[ELEMENTICY]

@SGaist dude,im so tired...
Can you pleaseee write the 3 lines of code for me?
Please... i hope after you see this message,you wont just ignore and think i never hard work on it..But im tired for just add a simple library already...
It will be the BEST help for me

My current code...

win32:CONFIG(release, debug|release): LIBS += $$PWD/lib/ -llibmysql
else:win32:CONFIG(debug, debug|release): LIBS += $$PWD/lib/ -llibmysqld
else:unix: LIBS += $$PWD/lib/ -llibmysql

Error:
:-1: error: error: cannot open C:/Users/ELEMENT/Documents/PosSystem/Pos/lib/: Permission denied
I opened QT Creator with Administrator,still same...

I also tried..

win32:CONFIG(release, debug|release): LIBS += $$PWD/lib/libmysql
else:win32:CONFIG(debug, debug|release): LIBS += $$PWD/lib/libmysqld
else:unix: LIBS += $$PWD/lib/libmysql

Error:
:-1: error: no such file or directory: 'C:/Users/ELEMENT/Documents/PosSystem/Pos/lib/libmysql' clang++: error: no such file or directory: 'C:/Users/ELEMENT/Documents/PosSystem/Pos/lib/libmysql' make: *** [Makefile:79: libPos_x86_64.so] Error 1
Seems like that one is the wrong way to do without adding -l

appreciate it...