Library not loaded: @rpath/libmysqlclient.24.dylib Mac M3

[chenlydia]

Hello, I tried to import MySQLdb but got error message as following:

>>> import MySQLdb
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Volumes/develop/Application/anaconda3/envs/chatchat/lib/python3.10/site-packages/MySQLdb/__init__.py", line 17, in <module>
    from . import _mysql
ImportError: dlopen(/Volumes/develop/Application/anaconda3/envs/chatchat/lib/python3.10/site-packages/MySQLdb/_mysql.cpython-310-darwin.so, 0x0002): Library not loaded: @rpath/libmysqlclient.24.dylib
  Referenced from: <C6591F36-06DD-3BEB-A41D-626B07A9D30D> /Volumes/develop/Application/anaconda3/envs/chatchat/lib/python3.10/site-packages/MySQLdb/_mysql.cpython-310-darwin.so
  Reason: tried: '/Volumes/develop/Application/anaconda3/envs/chatchat/lib/libmysqlclient.24.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/Volumes/develop/Application/anaconda3/envs/chatchat/lib/libmysqlclient.24.dylib' (no such file), '/Volumes/develop/Application/anaconda3/envs/chatchat/lib/libmysqlclient.24.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/Volumes/develop/Application/anaconda3/envs/chatchat/lib/libmysqlclient.24.dylib' (no such file), '/Volumes/develop/Application/anaconda3/envs/chatchat/bin/../lib/libmysqlclient.24.dylib' (no such file), '/Volumes/develop/Application/anaconda3/envs/chatchat/bin/../lib/libmysqlclient.24.dylib' (no such file)

I'm using M3 Macbookpro, OS: Sonoma 14.3
I installed mysqlclient in the directory /Volumes/develop/Application/anaconda3/envs/chatchat/lib/python3.10/site-packages/
and mysql v8.4.0 in the directory /usr/local/mysql

I set PKG_CONFIG_PATH=/usr/local/mysql/lib/pkgconfig

The library libmysqlclient.24.dylib is under the mysql installed directory but mysqlclient seems to search wrong paths.

[methane]

The library libmysqlclient.24.dylib is under the mysql installed directory but mysqlclient seems to search wrong paths.

Because you didn't teach the right path.

What is pkg-config mysqlclient --libs output?
You need to set the output with right rpath to MYSQLCLIENT_LDFLAGS envvar.

[methane]

You can ask how to setting rpath to AI.
https://x.com/i/grok/share/rlvHWhBEqjkWKe7jz5edmQZza