MacOS mysqlclient & psycopg2 환경 설정

개요

mysqlclient

오류

Exception: Can not find valid pkg-config name.
Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually

설정법

mysql 또는 mysql-client 설치

mysql

brew install mysql pkg-config

mysql-client

brew install mysql-client@8.4 pkg-config

echo 'export PATH="/opt/homebrew/opt/mysql-client@8.4/bin:$PATH"' >> ~/.zshrc
echo 'export LDFLAGS="-L/opt/homebrew/opt/mysql-client@8.4/lib"' >> ~/.zshrc
echo 'export CPPFLAGS="-I/opt/homebrew/opt/mysql-client@8.4/include"' >> ~/.zshrc
echo 'export PKG_CONFIG_PATH="/opt/homebrew/opt/mysql-client@8.4/lib/pkgconfig"' >> ~/.zshrc
source ~/.zshrc

환경변수 추가

# 값 확인
mysql_config --cflags
mysql_config --libs

# 설정
export MYSQLCLIENT_CFLAGS="$(mysql_config --cflags)"
export MYSQLCLIENT_LDFLAGS="$(mysql_config --libs)"

mysqlclient 설치

pip install mysqlclient

GitHub - PyMySQL/mysqlclient: MySQL/MariaDB connector for Python

MySQL/MariaDB connector for Python. Contribute to PyMySQL/mysqlclient development by creating an account on GitHub.

https://github.com/PyMySQL/mysqlclient

Did you install mysqlclient? 오류

pip install pymysql

import pymysql  
pymysql.install_as_MySQLdb()

Reference

GitHub - PyMySQL/mysqlclient: MySQL/MariaDB connector for Python

MySQL/MariaDB connector for Python. Contribute to PyMySQL/mysqlclient development by creating an account on GitHub.

https://github.com/PyMySQL/mysqlclient

Can not install apache-airflow-providers-mysql: pkg-config error

I'm using Debian/Ubuntu, and I am trying to install an Airflow provider in my Python virtual environment: $ pip install apache-airflow-providers-mysql error: subprocess-exited-with-error × Get...

https://stackoverflow.com/questions/76875507/can-not-install-apache-airflow-providers-mysql-pkg-config-error

`mysql-client` 9.0 does not include `mysql_native_password` plugin · Issue #180498 · Homebrew/homebrew-core

brew config HOMEBREW_VERSION: 4.3.12 ORIGIN: https://github.com/Homebrew/brew HEAD: 874d2da45344d3b27aa740e555b0210d8c474220 Last commit: 9 days ago Core tap JSON: 08 Aug 13:26 UTC Core cask tap JS...

https://github.com/Homebrew/homebrew-core/issues/180498

M1 error- Django mysql 연동 (Did you install mysqlclient?)

Problem >M1에서 mysql, mysql-client를 brew로 설치 이후, python manage.py runserver시 나오는 에러 메세지다. Solution > 로 pymysql을 설치해주고 setting.py 에 상기 코드를 추가해준다. +α mysql 'NAME', 'PASSWORD' 도 setting.py에 반영되어 있어야 접...

https://velog.io/@dwenup/M1-Django-mysql-연동-error-Did-you-install-mysqlclient

psycopg2

오류

running egg_info
writing psycopg2.egg-info/PKG-INFO
writing dependency_links to psycopg2.egg-info/dependency_links.txt
writing top-level names to psycopg2.egg-info/top_level.txt

Error: pg_config executable not found.

pg_config is required to build psycopg2 from source.  Please add the directory
containing pg_config to the $PATH or specify the full executable path with the
option:

    python setup.py build_ext --pg-config /path/to/pg_config build ...

or with the pg_config option in 'setup.cfg'.

If you prefer to avoid building psycopg2 from source, please install the PyPI
'psycopg2-binary' package instead.

For further information please check the 'doc/src/install.rst'

설정법

postgresql 설치

brew install postgresql

Reference

GitHub - psycopg/psycopg2: PostgreSQL database adapter for the Python programming language

PostgreSQL database adapter for the Python programming language - psycopg/psycopg2

https://github.com/psycopg/psycopg2