Django MySQLdb安装

上一篇 / 下一篇  2016-03-07 23:02:23 / 个人分类：Django

查看( 2188 ) / 评论( 0 ) / 评分( 0 / 0 )
安装MySQLdb的时候一共遇到三个问题
一、无法用pip安装-->下载安装包
二、找不到mysql_config-->更改安装包的setup_posix.py文件
三、32、64位不统一 -->环境变量统一一下
（后面两个问题比较特殊，在网上找的答案也有很多，但是第三个问题的答案多，但是正确答案找了好久）


下载mysql：

http://dev.mysql.com/downloads/mysql/

一、安装MySQL-python:

  1. ##pip 安装失败
  2. shylocks-MacBook-Pro:~ shylock$ pip install MySQL-python
  3. Downloading/unpacking MySQL-python
  4.  Downloading MySQL-python-1.2.5.zip (108kB): 108kB downloaded
  5.  Running setup.py (path:/private/var/folders/0j/0xt1k8xn5cb6td37hlb61hdm0000gn/T/pip_build_shylock/MySQL-python/setup.py) egg_info for package MySQL-python
  6.    
  7. Cleaning up...
  8. Exception:
  9. Traceback (most recent call last):
  10.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/basecommand.py", line 133, in main
  11.    status = self.run(options, args)
  12.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/commands/install.py", line 316, in run
  13.    requirement_set.prepare_files(
  14.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/commands/install.py", line 316, in run
  15.    requirement_set.prepare_files(
  16.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/req/req_set.py", line 397, in prepare_files
  17.    req_to_install.assert_source_matches_version()
  18.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/req/req_install.py", line 478, in assert_source_matches_version
  19.    version = self.installed_version
  20.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/req/req_install.py", line 474, in installed_version
  21.    return self.pkg_info()['version']
  22.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/req/req_install.py", line 442, in pkg_info
  23.    data = self.egg_info_data('PKG-INFO')
  24.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/req/req_install.py", line 371, in egg_info_data
  25.    data = read_text_file(filename)
  26.  File "/Users/shylock/jython2.7.0/Lib/site-packages/pip/util.py", line 777, in read_text_file
  27.    encodings = ['utf-8', locale.getpreferredencoding(False), 'latin1']
  28.  File "/Users/shylock/jython2.7.0/Lib/locale.py", line 574, in getpreferredencoding
  29.    return getdefaultlocale()[1]
  30.  File "/Users/shylock/jython2.7.0/Lib/locale.py", line 511, in getdefaultlocale
  31.    return _parse_localename(localename)
  32.  File "/Users/shylock/jython2.7.0/Lib/locale.py", line 443, in _parse_localename
  33.    raise ValueError, 'unknown locale: %s' % localename
  34. ValueError: unknown locale: UTF-8
  36. Storing debug log for failure in /Users/shylock/.pip/pip.log
  37. shylocks-MacBook-Pro:~ shylock$

下载安装包。

解决mysql_config not found 问题（前提必须本机安装了mysql，否则/usr/local/下没有mysql文件夹）

  1. 这时我们就不得不安装MySQLdb包了。安装其实也挺简单，具体步骤如下：
  2. 1、下载MySQLforPython
  3. 地址：http://sourceforge.net/projects/mysql-python/files/mysql-python/
  4. 我这里安装的是1.2.3版本
  5. 复制代码代码如下:
  6. wget http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz
  8. 2、解压
  9. 复制代码代码如下:
  10. tar zxvfMySQL-python-1.2.3.tar.gz
  12. 3、安装
  13. 复制代码代码如下:
  14. $ cdMySQL-python-1.2.3
  15. $ python setup.py build
  16. $ python setup.py install
  18. 注：
  19. 如果在执行：python setup.py build遇到以下错误：
  20. 复制代码代码如下:
  21. EnvironmentError:mysql_confignotfound
  23. 首先查找mysql_config的位置，使用
  24. find/-name mysql_config，比如我的在/usr/local/mysql/bin/mysql_config
  25. 修改setup_posix.py文件，在26行：
  26. mysql_config.path=“mysql_config”修改为：
  27. 复制代码代码如下:
  28. mysql_config.path=“/usr/local/mysql/bin/mysql_config”
  29. ####或者在环境变量中:export PATH=/usr/local/lib/wxPython-unicode-2.8.12.1/lib/python2.7/site-packages/wx-2.8-mac-unicode/wx/__init__.py:$PATH
  31. 保存后，然后再次执行：
  32. 复制代码代码如下:
  33. python setup.py build
  34. python setup.py install
  35. #如果有14个warning的话，给sudo权限即可
  37. OK，到此大功告成。

之后遇到一个没有映像的问题：

  1. shylocks-MacBook-Pro:MySQL-python-1.2.4b4shylock$ python
  2. Python2.7.6(default,Sep 92014,15:04:36)
  3. [GCC4.2.1CompatibleAppleLLVM6.0(clang-600.0.39)]on darwin
  4. Type"help","copyright","credits"or"license"formore information.
  5. >>>importMySQLdb
  6. Traceback(most recent call last):
  7.  File"<stdin>",line1,in<module>
  8.  File"MySQLdb/__init__.py",line19,in<module>
  9.    import_mysql
  10. ImportError: dlopen(/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.10-intel.egg/_mysql.so, 2):no suitable image found. Did find:
  11. /Library/Python/2.7/site-packages/MySQL_python

收藏 举报

TAG:

 

评分：0

我来说两句