MacOS安装mysqlclient

MacOS安装mysqlclient

1、安装brew包管理工具

/bin/zsh -c "$(curl -fsSL https://gitee.com/cunkai/HomebrewCN/raw/master/Homebrew.sh)"

2、安装mysql

brew install mysql

3、MySQL服务器中设置凭据

mysql_secure_installation

4、从登录名开始并作为后台服务

brew services start mysql

5、启动MySQL

mysql.server start

6、安装MySQL-Connector-c

brew install mysql-connector-c

7、编辑mysql_config

vim /usr/local/bin/mysql_config

8、更改mysql_config的lib为以下内容

libs="-L$pkglibdir"
libs="$libs -lmysqlclient -lssl -lcrypto"

9、安装XCode-

xcode-select --install

10、安装openssl

brew install openssl

11、将其路径添加到环境

export LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/

12、取消链接MySQL和链接的MySQL连接器mysql-connector-c

brew unlink mysql
brew link --overwrite mysql-connector-c

13、应该使用pip install mysqlclient而不会出现任何错误，如果有问题再执行14、15步骤

pip3 install mysqlclient==1.4.4 -i https://pypi.douban.com/simple

14、取消链接MySQL和链接的MySQL连接器mysql-connector-c

brew unlink mysql-connector-c
brew link --overwrite mysql --force

15、安装mysqlclient

pip3 install mysqlclient==1.4.4 -i https://pypi.douban.com/simple