Home >Database >Mysql Tutorial >在mac OS X中配置python mysql开发环境_MySQL

在mac OS X中配置python mysql开发环境_MySQL

WBOY
WBOYOriginal
2016-06-01 13:06:281500browse

python

1. 首先要下载安装mysql,下载地址:

http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.19.tar.gz

解压:

tar -xzvf mysql-5.6.19.tar.gz

然后下载gmock,编译mysql时需要用到:

https://googlemock.googlecode.com/files/gmock-1.7.0.zip

解压到指定目录

<span style="font-size:14px;">unzip gmock-1.6.0.zip -d mysql-5.6.19/source_downloads</span>

进入mysql source目录:

cd myslq-5.6.19

执行:

cmake .

make

make install

编译安装完成大概需要10多分钟。

也可以用brew install mysql --universal, 但是这个命令最近好像不能用了


2. 下载安装mysql-python

https://pypi.python.org/pypi/MySQL-python/1.2.5

解压后,需修改site.cfg文件:

找到这一行:

#mysql_config = /usr/local/bin/mysql_config

把注释去掉,改为:

mysql_config = /usr/local/mysql/bin/mysql_config

这句话指定你机器上mysql_config文件的路径

可以用find / -name mysql_config命令确认一下,如果你的mysql安装路径和本文不一样,以实际路径为准

然后,执行:

sudo python setup.py install


3. 安装成功后,进入python命令行,输入

import MySQLdb

会出现错误:

Library not loaded: libmysqlclient.18.dylib

这是由于python找不到mysql路径导致的,运行:

<code>sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib</code>
创建软链接后,即可解决此问题

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn