python mysqlclient 2.2.x 버전 설치 시 에러

(env) int@intui-MacBookAir potenday-309 % pip install mysqlclient             
Collecting mysqlclient
  Using cached mysqlclient-2.2.0.tar.gz (89 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... error
  error: subprocess-exited-with-error
  
  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
  ╰─> [24 lines of output]
      /bin/sh: pkg-config: command not found
      /bin/sh: pkg-config: command not found
      Trying pkg-config --exists mysqlclient
      Command 'pkg-config --exists mysqlclient' returned non-zero exit status 127.
      Trying pkg-config --exists mariadb
      Command 'pkg-config --exists mariadb' returned non-zero exit status 127.
      Traceback (most recent call last):
        File "/Users/int/Development/workspace/potenday-309/env/lib/python3.9/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 353, in <module>
          main()
        File "/Users/int/Development/workspace/potenday-309/env/lib/python3.9/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main
          json_out['return_val'] = hook(**hook_input['kwargs'])
        File "/Users/int/Development/workspace/potenday-309/env/lib/python3.9/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 118, in get_requires_for_build_wheel
          return hook(config_settings)
        File "/private/var/folders/gz/nfvkk1c10m3d7dy7_bwzy43m0000gn/T/pip-build-env-48994rpk/overlay/lib/python3.9/site-packages/setuptools/build_meta.py", line 355, in get_requires_for_build_wheel
          return self._get_build_requires(config_settings, requirements=['wheel'])
        File "/private/var/folders/gz/nfvkk1c10m3d7dy7_bwzy43m0000gn/T/pip-build-env-48994rpk/overlay/lib/python3.9/site-packages/setuptools/build_meta.py", line 325, in _get_build_requires
          self.run_setup()
        File "/private/var/folders/gz/nfvkk1c10m3d7dy7_bwzy43m0000gn/T/pip-build-env-48994rpk/overlay/lib/python3.9/site-packages/setuptools/build_meta.py", line 341, in run_setup
          exec(code, locals())
        File "<string>", line 154, in <module>
        File "<string>", line 48, in get_config_posix
        File "<string>", line 27, in find_package_name
      Exception: Can not find valid pkg-config name.
      Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error

× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> See above for output.

note: This error originates from a subprocess, and is likely not a problem with pip.

 

python에서 mysql을 사용하려고 pip를 이용해 mysqlclient를 설치하다 에러가 났다.

 

분명 다른 프로젝트에서는 잘 작동하였는데 찾아보니까 간단하였다.

 

2.2.0 버전이 2023년 6월 릴리스 되었으며 해당 버전 이후부터는 pkg-config 패키지를 container에 설치해야 한다.

 

맥북에 brew를 사용하여 pkg-config를 설치하자

 

brew install mysql pkg-config

 

설치를 완료하고 다시 mysqlclient를 설치하면

 

pip install mysqlclient

 

잘 설치된다.