ubuntu下安装python-mysqldb的报错

点击(此处)折叠或打开

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
    
15. 
    
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
    
43. 
    
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
     
107. 
     
108. 
     
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