Chinaunix首页 | 论坛 | 博客

hyunmin

首页　| 　博文目录　| 　关于我

sxm5211258

  • 博客访问： 385440
  • 博文数量： 112
  • 博客积分： 10
  • 博客等级： 民兵
  • 技术积分： 800
  • 用 户 组： 普通用户
  • 注册时间： 2010-12-29 13:41
文章分类

全部博文（112）

文章存档

2020年（1）

2018年（10）

2017年（27）

2016年（18）

2015年（31）

2014年（25）

我的朋友
最近访客
推荐博文
相关博文
ubuntu下安装python-mysqldb的报错

分类： Python/Ruby

2018-05-22 16:29:22



点击(此处)折叠或打开

  1. #安装mysql-server
  2. #apt-get install mysql-server
  3. #安装python-mysqldb
  4. #apt-get install python-mysqldb
  5. #python 
  6. Python 2.7.12 (default, Dec  4 2017, 14:50:18)
  7. [GCC 5.4.0 20160609] on linux2
  8. Type "help", "copyright", "credits" or "license" for more information.
  9. >>> import MySQLdb
  10. ... 
  11. ImportError: this is MySQLdb version (1, 2, 5, 'final', 1), but _mysql is version (1, 3, 7, 'final', 1) 
  12. #apt-get安装的MySQLdb和mysql版本不一致。
  13. #将python-mysqldb卸载
  14. #apt-get remove --purge python-mysqldb
  15. #用pip重新安装
  16. #pip install mysql-python

手动安装MySQL_python-1.2.5

点击(此处)折叠或打开

  1. #wget https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
  2. #unzip MySQL-python-1.2.5.zip
  3. #cd MySQL-python-1.2.5
  4. #python setup.py build
  5. #报错如下：
  6. sh: 1: mysql_config: not found
  7. Traceback (most recent call last):
  8.   File "setup.py", line 17, in <module>
  9.     metadata, options = get_config()
  10.   File "/home/ubuntu/MySQL-python-1.2.5/setup_posix.py", line 43, in get_config
  11.     libs = mysql_config("libs_r")
  12.   File "/home/ubuntu/MySQL-python-1.2.5/setup_posix.py", line 25, in mysql_config
  13.     raise EnvironmentError("%s not found" % (mysql_config.path,))
  14. EnvironmentError: mysql_config not found

  16. # apt-get install libmysqlclient-dev
  17. # python setup.py build
  18. running build
  19. running build_py
  20. creating build
  21. creating build/lib.linux-x86_64-2.7
  22. copying _mysql_exceptions.py -> build/lib.linux-x86_64-2.7
  23. creating build/lib.linux-x86_64-2.7/MySQLdb
  24. copying MySQLdb/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb
  25. copying MySQLdb/converters.py -> build/lib.linux-x86_64-2.7/MySQLdb
  26. copying MySQLdb/connections.py -> build/lib.linux-x86_64-2.7/MySQLdb
  27. copying MySQLdb/cursors.py -> build/lib.linux-x86_64-2.7/MySQLdb
  28. copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
  29. copying MySQLdb/times.py -> build/lib.linux-x86_64-2.7/MySQLdb
  30. creating build/lib.linux-x86_64-2.7/MySQLdb/constants
  31. copying MySQLdb/constants/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
  32. copying MySQLdb/constants/CR.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
  33. copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
  34. copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
  35. copying MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
  36. copying MySQLdb/constants/REFRESH.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
  37. copying MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
  38. running build_ext
  39. building '_mysql' extension
  40. creating build/temp.linux-x86_64-2.7
  41. x86_64-linux-gnu-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fno-strict-aliasing -Wdate-time -D_FORTIFY_SOURCE=2 -g -fstack-protector-strong -Wformat -Werror=fat-security -fPIC -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 -I/usr/include/mysql -I/usr/include/python2.7 -c _mysql.c -o build/temp.linux-x86_64-2.7/_mysql.o
  42. x86_64-linux-gnu-gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -Wl,-z,relro -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypesdate-time -D_FORTIFY_SOURCE=2 -g -fstack-protector-strong -Wformat -Werror=format-security -Wl,-Bsymbolic-functions -Wl,-z,relro -Wdate-time -D_FORTIFY_SOURCE=2 -g -fstack-protectstrong -Wformat -Werror=format-security build/temp.linux-x86_64-2.7/_mysql.o -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lz -lm -lrt -ldl -o build/lib.linux-x86_64-2.7/_ml.so

  44. # python setup.py install
  45. running install
  46. running bdist_egg
  47. running egg_info
  48. writing MySQL_python.egg-info/PKG-INFO
  49. writing top-level names to MySQL_python.egg-info/top_level.txt
  50. writing dependency_links to MySQL_python.egg-info/dependency_links.txt
  51. reading manifest file 'MySQL_python.egg-info/SOURCES.txt'
  52. reading manifest template 'MANIFEST.in'
  53. writing manifest file 'MySQL_python.egg-info/SOURCES.txt'
  54. installing library code to build/bdist.linux-x86_64/egg
  55. running install_lib
  56. running build_py
  57. copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
  58. running build_ext
  59. creating build/bdist.linux-x86_64
  60. creating build/bdist.linux-x86_64/egg
  61. creating build/bdist.linux-x86_64/egg/MySQLdb
  62. copying build/lib.linux-x86_64-2.7/MySQLdb/converters.py -> build/bdist.linux-x86_64/egg/MySQLdb
  63. copying build/lib.linux-x86_64-2.7/MySQLdb/cursors.py -> build/bdist.linux-x86_64/egg/MySQLdb
  64. copying build/lib.linux-x86_64-2.7/MySQLdb/__init__.py -> build/bdist.linux-x86_64/egg/MySQLdb
  65. copying build/lib.linux-x86_64-2.7/MySQLdb/release.py -> build/bdist.linux-x86_64/egg/MySQLdb
  66. copying build/lib.linux-x86_64-2.7/MySQLdb/connections.py -> build/bdist.linux-x86_64/egg/MySQLdb
  67. creating build/bdist.linux-x86_64/egg/MySQLdb/constants
  68. copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FIELD_TYPE.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants
  69. copying build/lib.linux-x86_64-2.7/MySQLdb/constants/__init__.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants
  70. copying build/lib.linux-x86_64-2.7/MySQLdb/constants/REFRESH.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants
  71. copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CR.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants
  72. copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CLIENT.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants
  73. copying build/lib.linux-x86_64-2.7/MySQLdb/constants/ER.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants
  74. copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FLAG.py -> build/bdist.linux-x86_64/egg/MySQLdb/constants
  75. copying build/lib.linux-x86_64-2.7/MySQLdb/times.py -> build/bdist.linux-x86_64/egg/MySQLdb
  76. copying build/lib.linux-x86_64-2.7/_mysql_exceptions.py -> build/bdist.linux-x86_64/egg
  77. copying build/lib.linux-x86_64-2.7/_mysql.so -> build/bdist.linux-x86_64/egg
  78. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/converters.py to converters.pyc
  79. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/cursors.py to cursors.pyc
  80. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/__init__.py to __init__.pyc
  81. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/release.py to release.pyc
  82. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/connections.py to connections.pyc
  83. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FIELD_TYPE.py to FIELD_TYPE.pyc
  84. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/__init__.py to __init__.pyc
  85. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/REFRESH.py to REFRESH.pyc
  86. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CR.py to CR.pyc
  87. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CLIENT.py to CLIENT.pyc
  88. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/ER.py to ER.pyc
  89. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FLAG.py to FLAG.pyc
  90. byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/times.py to times.pyc
  91. byte-compiling build/bdist.linux-x86_64/egg/_mysql_exceptions.py to _mysql_exceptions.pyc
  92. creating stub loader for _mysql.so
  93. byte-compiling build/bdist.linux-x86_64/egg/_mysql.py to _mysql.pyc
  94. creating build/bdist.linux-x86_64/egg/EGG-INFO
  95. copying MySQL_python.egg-info/PKG-INFO -> build/bdist.linux-x86_64/egg/EGG-INFO
  96. copying MySQL_python.egg-info/SOURCES.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
  97. copying MySQL_python.egg-info/dependency_links.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
  98. copying MySQL_python.egg-info/top_level.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
  99. writing build/bdist.linux-x86_64/egg/EGG-INFO/native_libs.txt
  100. zip_safe flag not set; analyzing archive contents...
  101. creating dist
  102. creating 'dist/MySQL_python-1.2.5-py2.7-linux-x86_64.egg' and adding 'build/bdist.linux-x86_64/egg' to it
  103. removing 'build/bdist.linux-x86_64/egg' (and everything under it)
  104. Processing MySQL_python-1.2.5-py2.7-linux-x86_64.egg
  105. Copying MySQL_python-1.2.5-py2.7-linux-x86_64.egg to /usr/local/lib/python2.7/dist-packages
  106. Adding MySQL-python 1.2.5 to easy-install.pth file


  109. Installed /usr/local/lib/python2.7/dist-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg
  110. Processing dependencies for MySQL-python==1.2.5
  111. Finished processing dependencies for MySQL-python==1.2.5











阅读(1525) | 评论(0) | 转发(0) |
0

上一篇：python在windows下连接mysql数据库

下一篇：python管理mysql

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6