解决Mac Python 安装mysqlclient失败

• 执行pip install mysqlclient或poetry add mysqlclient安装mysqlclient时提示安装失败，提示如下

Collecting mysqlclient
  Downloading mysqlclient-2.2.7.tar.gz (91 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 91.4/91.4 kB 672.9 kB/s eta 0:00:00
  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
  ╰─> [31 lines of output]
      Trying pkg-config --exists mysqlclient
      Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
      Trying pkg-config --exists mariadb
      Command 'pkg-config --exists mariadb' returned non-zero exit status 1.
      Trying pkg-config --exists libmariadb
      Command 'pkg-config --exists libmariadb' returned non-zero exit status 1.
      Trying pkg-config --exists perconaserverclient
      Command 'pkg-config --exists perconaserverclient' returned non-zero exit status 1.
      Traceback (most recent call last):

• 需要安装mysql-client

安装mysql-client

• 执行brew install mysql-client命令安装，安装成功后会提示如下

==> Caveats
==> mysql-client
mysql-client is keg-only, which means it was not symlinked into /usr/local,
because it conflicts with mysql (which contains client libraries).

If you need to have mysql-client first in your PATH, run:
  echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.zshrc

For compilers to find mysql-client you may need to set:
  export LDFLAGS="-L/usr/local/opt/mysql-client/lib"
  export CPPFLAGS="-I/usr/local/opt/mysql-client/include"

• 需要在~/.zshrc配置以下参数
• export PATH="/usr/local/opt/mysql-client/bin:$PATH"
• export LDFLAGS="-L/usr/local/opt/mysql-client/lib"
• export CPPFLAGS="-I/usr/local/opt/mysql-client/include"
• export PKG_CONFIG_PATH="/usr/local/opt/mysql-client/lib/pkgconfig"
• 再执行mysqlclient安装命令即可安装成功