Mac系统 python2.7中安装MySQLdb
2024-10-08 06:45:28
由于要在python2.7上使用到MySQLdb连接数据库,所以要安装MySQLdb,也就是MySQL-Python。安装之前已经有人告诉我,这个东西比较难装,果然我也遇到好多问题,在百度找了半天,发现好多大佬写下了遇到坑的经历,按照大佬们的方式,我也没有解决,最后是根据报错解决了。
看到有大佬根据知乎上的问题总结了两条命令,对,我也是按照这两条命令执行的:
1. brew install mysql-connector-c
2. pip install mysql-python
安装第一个很顺利,然后接着安装第2项内容,报错如下:
xhdeMacBook-Pro:bin xhong$ pip install MySQL-python
Collecting MySQL-python
Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
Complete output from command python setup.py egg_info:
/usr/local/bin/mysql_config: line : syntax error near unexpected token `newline'
get_full_path ()
/usr/local/bin/mysql_config: line : `> # Create options '
Traceback (most recent call last):
File "<string>", line , in <module>
File "/private/var/folders/v6/wvt9z78x4ksd_5fhltwjygd00000gn/T/pip-install-AS6vkS/MySQL-python/setup.py", line , in <module>
metadata, options = get_config()
File "setup_posix.py", line , in get_config
libs = mysql_config("libs_r")
File "setup_posix.py", line , in mysql_config
raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: mysql_config not found
百度了半天,有的说是修改mysql_config文件,按照这篇:https://www.easegamer.com/?p=545;我修改了也没用。修改之后再次安装报错如下:
xhdeMacBook-Pro:bin xhong$ pip install MySQL-python
Collecting MySQL-python
Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
Complete output from command python setup.py egg_info:
/usr/local/bin/mysql_config: line : syntax error near unexpected token `newline'
/usr/local/bin/mysql_config: line : `> # Create options '
Traceback (most recent call last): File "<string>", line , in <module> File "/private/var/folders/v6/wvt9z78x4ksd_5fhltwjygd00000gn/T/pip-install-VOZ85j/MySQL-python/setup.py", line , in <module>
metadata, options = get_config()
File "setup_posix.py", line , in get_config
libs = mysql_config("libs_r")
File "setup_posix.py", line , in mysql_config
raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: mysql_config not found
提示环境问题,之后又尝试将mysql_config这个文件的路径加入环境变量,如下:
#安装MySQL-python需要配置的环境变量
export PATH=${PATH}:/usr/local/Cellar/mysql-connector-c/6.1./bin/
export PATH=${PATH}:/usr/local/bin/
结果再次安装还是报错上面的一样,最后实在没法,就仔细看了报错的信息:
这个报错信息说的是 /usr/local/bin/这个路径下面的mysql_config文件中有语法错误
最新文章
- [LeetCode] Text Justification 文本左右对齐
- http://blog.csdn.net/a491057947/article/details/46724707
- 44.do文件格式
- (转载)浅谈我对DDD领域驱动设计的理解
- 【原创】利用Windows系统日志统计员工每天上下班考勤时间
- Altium Designer(DXP)小技巧之模块化布局
- 设计模式——组合模式(C++实现)
- [Codeforces]762F - Tree nesting
- 关于postgresql group by 报错
- 转:浅谈SimpleDateFormat的线程安全问题
- javascript 模板
- flask 连接MogoDB数据库
- Map Wiki -- proposed by Shuo Ren
- 【Java】 int与char类型间的相互转化
- GIS(地理信息系统)
- BootStrap-select 插件的使用
- Java调用存储过程小结
- seacms 6.45 命令执行漏洞分析
- 【bzoj4695】最假女选手 线段树区间最值操作
- MongoDB 日志太大怎么办?