python2.7之MySQLdb模块 for linux安装
来源:互联网 发布:kali linux入门教程 编辑:程序博客网 时间:2024/05/27 09:47
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
连接数据库错误:
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "MySQLdb/connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")
原因没有安装mysql-server
- python2.7之MySQLdb模块 for linux安装
- python2.7之MySQLdb模块 for linux安装
- python2.7之MySQLdb模块 for linux安装
- python2.7安装MySQLdb模块
- python2.7.12安装MySQLdb模块
- python MySQLdb模块 for linux安装
- Python2.7安装MySQLdb
- python2.7安装MySQLdb
- Python+MySQL学习之路:一、为Windows下python2.7安装MySQLdb模块
- SUSE安装python2.4的MySQLdb模块
- python2.7.13安装MySQLdb模块及使用
- ubuntu10.04 安装MySQLdb for python2.6
- ubuntu python2.7安装MySQLdb
- 安装MySQLdb for Linux
- linux下安装MySQLdb模块
- Linux下安装MySQLdb模块
- Linux下安装 MySQLdb模块 MySQL-python 坎坷之路
- linux 安装 MySQLdb for python
- [ORACLE]数据字典视图大全
- 正确的设置相机参数 setViewMatrixAsLookAt
- 安装Ubuntu16.04与windows10双系统后,如何修改启动默认设置
- 堆排序原理及算法实现(最大堆)
- 改变控件的背景颜色和字体颜色
- python2.7之MySQLdb模块 for linux安装
- Script函数 入门
- CSS3总结(1)
- json教程--什么是jsonp?
- node搭建微信平台(二)-接入配置
- yuv422sp to yuv422p
- 针对SSL的中间人攻击演示和防范
- 人类大脑到人工智能合并技术已经在开发
- java.lang.IllegalStateException: File has been moved - cannot be read again