python2.7之MySQLdb模組 for linux安裝
python2.7之MySQLdb模組 for linux安裝
1.下載:MySQL-python
http://sourceforge.net/projects/mysql-python/files/mysql-python-test/1.2.3b1/MySQL-python-1.2.3b1.tar.gz/download
tar -zxf MySQL-python-1.2.3b1.tar.gz
cd MySQL-python-1.2.3b1
python setup.py build
==>ImportError: No module named setuptools
2.下載setuptools
http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c8.tar.gz
tar -zxf setuptools-0.6c8.tar.gz
cd setuptools-0.6c8
python setup.py build
python setup.py install
3.回到MySQL-python-1.2.3b目錄
cd MySQL-python-1.2.3b1
在執行時python setup.py build && python setup.py install沒有如下錯誤:
有類似錯誤,處理方式如下:
python setup.py build #若,報錯:mysql_config not found
找出mysql 安裝目錄:/opt/mysql/
vi MySQL-python-1.2.3b1/setup_posix.py
行 26 #mysql_config.path = "mysql_config"
改成如下:
行 27 mysql_config.path = "/opt/mysql/bin/mysql_config"
再次執行
python setup.py build #報錯:/usr/bin/ld:cannot find -lmysqlclient_r
root下:
echo "/opt/mysql/lib/mysql" >> /etc/ld.so.conf #請主意這個/etc/ld.so.conf,
這個是ld的預設配置檔案,視系統不同而不同。 /opt/mysql/lib/mysql與mysql安裝目錄相關。
重新整理ld配置檔案讓其生效,使用:ldconfig
接著執行 python setup.py install
檢驗是否已經安裝成功MySQLdb時,提示如下錯誤:
>>> import MySQLdb
/usr/lib/python2.4/site-packages/MySQL_python-1.2.3b1-py2.4-linux-i686.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib/python2.4/site-packages/MySQL_python-1.2.3b1-py2.4-linux-i686.egg/_mysql.pyc, but /data/MySQL-python-1.2.3b1 is being added to sys.path
Traceback (most recent call last):
File "", line 1, in ?
File "MySQLdb/__init__.py", line 19, in ?
import _mysql
File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
File "build/bdist.linux-i686/egg/_mysql.py", line 6, in __bootstrap__
ImportError: libmysqlclient_r.so.16: cannot open shared object file: No such file or directory
解決方法:
vi /etc/profile下加:
export LD_LIBRARY_PATH=/opt/mysql/lib/mysql:$LD_LIBRARY_PATH
參考:
http://developer.51cto.com/art/201003/188263.htm
http://daxi.me/2009/08/99/
1.下載:MySQL-python
http://sourceforge.net/projects/mysql-python/files/mysql-python-test/1.2.3b1/MySQL-python-1.2.3b1.tar.gz/download
tar -zxf MySQL-python-1.2.3b1.tar.gz
cd MySQL-python-1.2.3b1
python setup.py build
==>ImportError: No module named setuptools
2.下載setuptools
http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c8.tar.gz
tar -zxf setuptools-0.6c8.tar.gz
cd setuptools-0.6c8
python setup.py build
python setup.py install
3.回到MySQL-python-1.2.3b目錄
cd MySQL-python-1.2.3b1
在執行時python setup.py build && python setup.py install沒有如下錯誤:
有類似錯誤,處理方式如下:
python setup.py build #若,報錯:mysql_config not found
找出mysql 安裝目錄:/opt/mysql/
vi MySQL-python-1.2.3b1/setup_posix.py
行 26 #mysql_config.path = "mysql_config"
改成如下:
行 27 mysql_config.path = "/opt/mysql/bin/mysql_config"
再次執行
python setup.py build #報錯:/usr/bin/ld:cannot find -lmysqlclient_r
root下:
echo "/opt/mysql/lib/mysql" >> /etc/ld.so.conf #請主意這個/etc/ld.so.conf,
這個是ld的預設配置檔案,視系統不同而不同。 /opt/mysql/lib/mysql與mysql安裝目錄相關。
重新整理ld配置檔案讓其生效,使用:ldconfig
接著執行 python setup.py install
檢驗是否已經安裝成功MySQLdb時,提示如下錯誤:
>>> import MySQLdb
/usr/lib/python2.4/site-packages/MySQL_python-1.2.3b1-py2.4-linux-i686.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib/python2.4/site-packages/MySQL_python-1.2.3b1-py2.4-linux-i686.egg/_mysql.pyc, but /data/MySQL-python-1.2.3b1 is being added to sys.path
Traceback (most recent call last):
File "
File "MySQLdb/__init__.py", line 19, in ?
import _mysql
File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
File "build/bdist.linux-i686/egg/_mysql.py", line 6, in __bootstrap__
ImportError: libmysqlclient_r.so.16: cannot open shared object file: No such file or directory
解決方法:
vi /etc/profile下加:
export LD_LIBRARY_PATH=/opt/mysql/lib/mysql:$LD_LIBRARY_PATH
參考:
http://developer.51cto.com/art/201003/188263.htm
http://daxi.me/2009/08/99/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26855487/viewspace-1063395/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 安裝MySQLdb模組MySql
- Linux下python2.7安裝pipLinuxPython
- linux 安裝 python2.7 +配置mysqlLinuxPythonMySql
- Python 3安裝MySQLdbPythonMySql
- MySQLdb的安裝與使用MySql
- Python2.7安裝Python
- Ubuntu 上安裝python2.7UbuntuPython
- Linux CentOS6編譯安裝Python2.7薦LinuxCentOS編譯Python
- windows7環境下使用pip安裝MySQLdbWindowsMySql
- 在CentOS 6.5上安裝python2.7CentOSPython
- 在pycharm安裝MySQLdb庫和pymysql庫的區別PyCharmMySql
- Python2.7安裝Scrapy錯誤處理Python
- python2.7安裝不了怎麼解決Python
- Pythonmysql-python安裝Python2.7PythonMySql
- ffmpeg安裝之linux編譯安裝Linux編譯
- Linux安裝之Linux mintLinux
- CentOS6.8 安裝python2.7,pip以及yumCentOSPython
- centos7 安裝python2.7與3共存CentOSPython
- CentOS6.5上安裝Python2.7和PIPCentOSPython
- PyMySQL模組安裝MySql
- php模組安裝PHP
- 解決centos7 安裝MySQLdb-python 報錯 方案CentOSMySqlPython
- 在Windows和Linux上安裝paramiko模組薦WindowsLinux
- php 安裝zip模組PHP
- Python模組安裝Python
- windows 安裝 Pillow 模組Windows
- nginx安裝echo模組Nginx
- perl cpan 模組安裝
- python2.7在windows環境安裝talib的方法PythonWindows
- Linux:Python報錯:No module named MySQLdbLinuxPythonMySql
- linux操作之軟體安裝(一)Linux
- Linux命令之rpm安裝命令Linux
- Linux - Vsftp之安裝和配置LinuxFTP
- pip進行模組安裝
- pycharm安裝python模組PyCharmPython
- OpenStack安裝(四)-Neutron模組
- pip安裝模組失敗
- OpenStack安裝(三) Nova模組