QMYSQL driver not loaded on mac

[Amit Talbot]

im using qt 5.9 and isolated install on mysql 5.7.20 on mac this piece of code worked like charm for me

brew install mysql-connector-c

I already had MAMP installed.... and wanted to use the mysql from mamp running on port 8889 this code helped me to do that

```

db.setHostName("localhost");
db.setConnectOptions("UNIX_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock");
db.setDatabaseName("xxxxxx");
db.setUserName("root");
db.setPassword("root");
db.setPort(8889);

[edwinxxxx]

Hi, what i have done are as pervious.but it shows that

//-bash: /Users/lucas/Qt5.9.8/5.9.8/clang_64/plugins/sqldrivers/libqsqlmysql.dylib: cannot execute binary file"

how can i fix it? thx for your help:)

[jsulm]

@edwinxxxx said in QMYSQL driver not loaded on mac:

/Users/lucas/Qt5.9.8/5.9.8/clang_64/plugins/sqldrivers/libqsqlmysql.dylib

You can't execute a library.
What are you trying to do?

[edwinxxxx]

@jsulm coz mysql driver can't be loaded in qt creator , i followed the directions above which has been proved that it was a successful way to solve the problem.but error happens.

[jsulm]

@edwinxxxx Please tell us the exact step your executing when you get that error message

[edwinxxxx]

@jsulm

[jsulm]

@edwinxxxx The last thig you did does not make sense: you're trying to execute a lib.
The first one was not successful - you called it in a wrong way. Take a look at its output ("Usage:"), it explains how to call it.
@SGaist - you're the Mac expert, can you take a look?

[edwinxxxx]

@jsulm thanks for your tips.i have wasted the whole day to solve it😂

[SGaist]

@edwinxxxx so it's now working correctly ?

[edwinxxxx]

@sgaist
platform: macos 10.14
mysql 8.0.17
qt 5.9.8

firstly i run

//otool -L libqsqlmysql.dylib

but it shows

/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/objdump: 'libqsqlmysql.dylib': No such file or directory

how can i find the path like "opt/local..." on my machine?
thanks man.

[jsulm]

@edwinxxxx said in QMYSQL driver not loaded on mac:

how can i find the path like "opt/local..." on my machine?

find / -name libqsqlmysql.dylib

[edwinxxxx]

@jsulm sorry, i still cant find any folder whose name begin with "/opt/local..."

[jsulm]

@edwinxxxx "/opt" is a system folder just under root /

[edwinxxxx]

@jsulm is that mean i cant locate the file "libmysqlclient.xx.dylib" in my pc?

[jsulm]

@edwinxxxx No, it doesn't mean that. If it is somewhere on your machine you can find it.
Where did you install it?
Did you try what I suggested?

find / -name libmysqlclient.*.dylib

[edwinxxxx]

@jsulm Yes! it shows a lot of contents, and the related information is

[jsulm]

@edwinxxxx So, it is in /usr/local, not /opt/local.

[edwinxxxx]

@jsulm when i call "otool -L " it indicates that

libqsqlmysql.dylib (compatibility version 0.0.0, current version 0.0.0)
	@rpath/QtSql.framework/Versions/5/QtSql (compatibility version 5.9.0, current version 5.9.8)
	@rpath/QtCore.framework/Versions/5/QtCore (compatibility version 5.9.0, current version 5.9.8)
	/System/Library/Frameworks/DiskArbitration.framework/Versions/A/DiskArbitration (compatibility version 1.0.0, current version 1.0.0)
	/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit (compatibility version 1.0.0, current version 275.0.0)
	/usr/local/mysql/lib/libmysqlclient.20.dylib (compatibility version 20.0.0, current version 20.0.0)
	/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 307.5.0)
	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1238.50.2)

so according to other's experience i run

install_name_tool -change/usr/local/mysql/lib/libmysqlclient.20.dylib/usr/local/mysql-8.0.17-macos10.14-x86_64/lib/libmysqlclient.21.dylib/Users/edwinxxxx/Qt5.9.8/5.9.8/clang_64/plugins/sqldrivers/libqsqlmysql.dylib

however,it seems didn't work still.

Usage: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/install_name_tool [-change old new] ... [-rpath old new] ... [-add_rpath new] ... [-delete_rpath old] ... [-id name] input

[jsulm]

@edwinxxxx said in QMYSQL driver not loaded on mac:

install_name_tool -change/usr/local/mysql/lib/libmysqlclient.20.dylib/usr/local/mysql-8.0.17-macos10.14-x86_64/lib/libmysqlclient.21.dylib/Users/edwinxxxx/Qt5.9.8/5.9.8/clang_64/plugins/sqldrivers/libqsqlmysql.dylib

I'm really not an MacOS expert, but don't you miss spaces here? Everything adter -change is one string without any separation via spaces.

[edwinxxxx]

@jsulm woooow! i add the spaces and the error disappear!
REALLY REALLY thanks!!!!