Centos环境下MySQL-python安装过程
来源:互联网 发布:caxa机械制图软件 编辑:程序博客网 时间:2024/05/16 04:33
1. 下载 MySQL-python-1.2.3.tar.gz
地址 https://sourceforge.net/projects/mysql-python/
2. 安装 MySQl-python
tar xvf MySQL-python-1.2.3.tar.gz
cd MySQL-python-1.2.3
vi site.cfg
把 mysql_config = /usr/local/mysql/bin/mysql_config 这一行前的#去掉,并且把mysql_config的路径设置正确。
python setup.py build
运行上面的命令报错如下:
Traceback (most recent call last):
File "setup.py", line 5, in ?
from setuptools import setup, Extension
ImportError: No module named setuptools
解决方法:
wget http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gztar zxvf setuptools-0.6c11.tar.gz
cd setuptools-0.6c11
python setup.py build
python setup.py install出现错误
_mysql.c:36:23: 错误:my_config.h:没有那个文件或目录
_mysql.c:38:19: 错误:mysql.h:没有那个文件或目录
_mysql.c:39:26: 错误:mysqld_error.h:没有那个文件或目录
_mysql.c:40:20: 错误:errmsg.h:没有那个文件或目录
设置include 头文件路径
export C_INCLUDE_PATH=/usr/local/mysql/include/mysql
继续安装:
python setup.py buildpython setup.py install
运行测试:
[root@localhost MySQL-python-1.2.3]# pythonPython 2.4.3 (#1, Sep 3 2009, 15:37:37)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
/usr/lib64/python2.4/site-packages/MySQL_python-1.2.3-py2.4-linux-x86_64.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib64/python2.4/site-packages/MySQL_python-1.2.3-py2.4-linux-x86_64.egg/_mysql.pyc, but /opt/python/MySQL-python-1.2.3 is being added to sys.path
>>>
报出一大堆警告信息,解决办法:删除MySQL-python源目录,再测试一下:
[root@localhost python]# pythonPython 2.4.3 (#1, Sep 3 2009, 15:37:37)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>>
Mysql模块终于正常了!
报错:
ImportError: libmysqlclient_r.so.16: cannot open shared object file: No such file or directory
1.确定libmysqlclient_r.so.16的位置
/usr/local/mysql/lib/mysql/libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
2.确定libmysqlclient_r.so.16使用的函数库及其位置
ldd /usr/local/mysql/lib/mysql/libmysqlclient_r.so.16
/usr/local/mysql/lib/mysql/libmysqlclient_r.so.16.0.0
ldd -v /usr/local/mysql/lib/mysql/libmysqlclient_r.so.16
/lib64
3.拷贝函数库到需要位置
cp -af /usr/local/mysql/lib/mysql/libmysqlclient_r.so.16.0.0 /lib64 或者 vim /etc/ld.so.conf将/usr/local/mysql/lib/mysql该目录添加到第一行
4.ldconfig
5.ldconfig -v | grep libmysqlclient_r.so.16
import MySQLdb sucess!!!!
本文出自 “运维笔记” 博客,请务必保留此出处http://lihuipeng.blog.51cto.com/3064864/887967
- Centos环境下MySQL-python安装过程
- Linux环境下MySQL-python安装过程
- Linux环境下MySQL-python安装过程
- Linux环境下MySQL-python安装过程
- Linux环境下MySQL-python安装过程
- Linux环境下MySQL-python安装过程
- Linux环境下MySQL-python安装过程
- centos环境下安装mysql
- centos下安装MySQL-python
- Centos下Python整体环境安装
- centos环境下如何安装Mysql数据库
- Centos/Ubuntu环境下安装mysql
- CentOS环境下安装Apache+PHP+Mysql
- centos下安装nginx+mysql+php环境
- Linux(CentOS)环境下安装MySQL
- 在CentOS环境下安装mysql数据库
- Centos环境下mysql源码编译安装
- Centos 下 安装 flask ,Mysql-python 步骤
- cetia4 sdk 下载地址
- Kettle java调用
- “真正”的程序员
- USB摄像头采集图像(DirectShow)
- Winrar4.11免费破解版(破解方法/激活码)
- Centos环境下MySQL-python安装过程
- 正则表达式的构造摘要
- Android学习笔记3--“Android SDK Content loader has encountered a problem” “parseSdkContent Failed ”
- 递归算法学习———汉诺塔
- BPMN2新规范与Activiti5 (Activiti5的特性介绍)
- BigDecimal类
- 关于论坛建设问题
- GridControl详解(四)分组排序汇总
- 安装完mysql-python后import加载模块 ImportError: libmysqlclient_r.so.16