关于MySQL-python-1.2.3.tar.gz安装失败的解决方案
RHEL6.4升级到python2.7.9，然后安装 MySQL-Python-1.2.3.tar.gz，报错。解决错误之后，运行：
python2.7 -c &import MySQLdb&
&&& import MySQLdb &
Traceback (most recent call last): &
File &&stdin&&, line 1, in &module& &
File &/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py&, line 19, in &module& &
File &/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/_mysql.py&, line 7, in &module& &
File &/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/_mysql.py&, line 6, in __bootstrap__ &
ImportError: /root/.python-eggs/MySQL_python-1.2.3-py2.7-linux-x86_64.egg-tmp/_mysql.so: undefined symbol: _ZTVN10__cxxabiv120__si_class_type_infoE
找了很多解决方法都无效。转而使用mysql官方的python连接器 mysql-connector-python。下载后安装：
# for mysql5.5+ &
$ wget http://ftp.ntu.edu.tw/MySQL/Downloads/Connector-Python/mysql-connector-python-2.1.1.tar.gz
# for mysql 4.1, 5.0, 5.1+ &
$ wget http://ftp.ntu.edu.tw/MySQL/Downloads/Connector-Python/mysql-connector-python-1.2.0.tar.gz
# or download from my ftp site: &
$ wget ftp://pub:/tarball/mysql-connector-python-1.2.0.tar.gz$ wget ftp://pub:/tarball/mysql-connector-python-2.1.1.tar.gz
# install it: &
$ tar zxf mysql-connector-python-1.2.0.tar.gz &
$ cd mysql-connector-python-1.2.0 &
$ python2.7 setup.py build &
$ sudo python2.7 setup.py install
然后测试：
import mysql.connector
&&& conn=mysql.connector.connect(user='root', password='******', host='127.0.0.1', database='devops')
Traceback (most recent call last):
File &&stdin&&, line 2, in &module&
File &/usr/local/lib/python2.7/site-packages/mysql/connector/__init__.py&, line 176, in connect
return MySQLConnection(*args, **kwargs)
File &/usr/local/lib/python2.7/site-packages/mysql/connector/connection.py&, line 95, in __init__
self.connect(**kwargs)
File &/usr/local/lib/python2.7/site-packages/mysql/connector/abstracts.py&, line 719, in connect
self._open_connection()
File &/usr/local/lib/python2.7/site-packages/mysql/connector/connection.py&, line 213, in _open_connection
self._ssl)
File &/usr/local/lib/python2.7/site-packages/mysql/connector/connection.py&, line 144, in _do_auth
self._auth_switch_request(username, password)
File &/usr/local/lib/python2.7/site-packages/mysql/connector/connection.py&, line 180, in _auth_switch_request
raise errors.get_exception(packet)
mysql.connector.errors.DatabaseError: 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords.
解决方法参考：
/doc/refman/5.6/en/password-expiration-sandbox-mode.html
就是mysql密码过期，重设一下就OK:
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement &
mysql& SET PASSWORD=PASSWORD('new pass here'); &
Query OK, 0 rows affected (0.00 sec)
然后再试：
&&& config={
... & & 'user':'root',
... & & 'password':'***********',
... & & 'host':'127.0.0.1',
... & & 'database':'devops',
&&& conn = mysql.connector.connect(**config)
&&& cur = conn.cursor()
&&& q=&SELECT * FROM packages&
&&& cur.execute(q)
&&& for row in cur:
... & & print row
(1, u'kbc', u'krb5-workstation', u'kerberos', None, None, None)
(2, u'kbs', u'krb5-server', u'kerberos', None, None, None)
(3, u'hadn', u'hadoop-hdfs-datanode', u'hadoop', u'hadoop-hdfs-datanode', u'hann', None)
(4, u'hamr', u'hadoop-mapreduce', u'hadoop', None, None, None)
(5, u'hanm', u'hadoop-yarn-nodemanager', u'hadoop', u'hadoop-yarn-nodemanager', None, None)
(6, u'hajn', u'hadoop-hdfs-journalnode', u'hadoop', u'hadoop-hdfs-journalnode', u'hazk', None)
(7, u'hann', u'hadoop-hdfs-namenode', u'hadoop', u'hadoop-hdfs-namenode', u'hajn', None)
(8, u'hazk', u'hadoop-hdfs-zkfc', u'hadoop', u'hadoop-hdfs-zkfc', u'zksvr', None)
(9, u'halzo', u'hadoop-lzo', u'hadoop', None, None, None)
(10, u'halib', u'hadoop-libhdfs', u'halibhdfs', None, None, None)
(11, u'halibd', u'hadoop-libhdfs-devel', u'halibhdfs', None, None, None)
(12, u'hares', u'hadoop-yarn-resourcemanager', u'hadoop', u'hadoop-yarn-resourcemanager', None, None)
(13, u'hahis', u'hadoop-mapreduce-historyserver', u'hadoop', u'hadoop-mapreduce-historyserver', u'hann', None)
(14, u'hbma', u'hbase-master', u'hbase', u'hbase-master', u'hann', None)
(15, u'hbreg', u'hbase-regionserver', u'hbase', u'hbase-regionserver', u'hbma', None)
(16, u'hbrst', u'hbase-rest', u'hbase', None, None, None)
(17, u'hbthr', u'hbase-thrift', u'hbase', None, None, None)
(18, u'hvbas', u'hive', u'hive', None, None, None)
(19, u'hvhb', u'hive-hbase', u'hive', None, None, None)
(20, u'hvms', u'hive-metastore', u'hive', u'hive-metastore', None, None)
(21, u'hvsvr', u'hive-server2', u'hive', u'hive-server2', None, None)
(22, u'hvjdbc', u'hive-jdbc', u'hive', None, None, None)
(23, u'hvhc', u'hive-hcatalog', u'hive', None, None, None)
(24, u'hvwhs', u'hive-webhcat-server', u'hive', None, None, None)
(25, u'hvwhc', u'hive-webhcat', u'hive', None, None, None)
(26, u'imcat', u'impala-catalog', u'impala', u'impala-catalog', None, None)
(27, u'imsvr', u'impala-server', u'impala', u'impala-server', None, None)
(28, u'imsh', u'impala-shell', u'impala', None, None, None)
(29, u'imss', u'impala-state-store', u'impala', u'impala-state-store', None, None)
(30, u'sphis', u'spark-history-server', u'spark', None, None, None)
(31, u'spma', u'spark-master', u'spark', None, None, None)
(32, u'spwkr', u'spark-worker', u'spark', None, None, None)
(33, u'zkbas', u'zookeeper', u'zookeeper', None, None, None)
(34, u'zksvr', u'zookeeper-server', u'zookeeper', u'zookeeper-server', None, None)
&&& cur.close()
&&& conn.close()
一切正常！
/doc/connector-python/en/connector-python-installation-source.html
下载地址：
http://ftp.ntu.edu.tw/MySQL/Downloads/Connector-Python/
官方开发接口参考：
/doc/connector-python/en/connector-python-example-cursor-select.html
本文永久更新地址：
------分隔线----------------------------windows下面安装Python和pip终极教程 - 推酷
windows下面安装Python和pip终极教程
在大二的时候接触过一段时间的Python，最近又开始玩起了这门语言。总的来说，个人很喜欢Python的语言风格，但是这门语言对于windows并不算很友好，因为如果是初学者在windows环境下安装，简直是折磨人，会遇到各种蛋疼的情况。本文希望提供傻瓜式的教程，能够令读者成功安装Python和pip。
第一步，我们先来安装Python，博主选择的版本是最新的3.4.2版本。windows下面的Python安装一般是通过软件安装包安装而不是命令行，所以我们首先要在Python的官方主页上面下载最新的Python安装包。下载地址是：https://www.python.org/downloads/
在下载完成之后，一直点击下一步就OK了。在安装完成之后，打开控制台，输入“Python”，我们能够看到下面的效果：
原因很简单，是因为python.exe文件在 Python 目录下，我们还没有设置环境变量。所以我们需要手动添加环境变量：鼠标右键我的电脑 &-& 属性 -& 点击高级系统设置 -& 点击环境变量 -& 点击PATH -& 在最后面加上我们的Python安装路径 -& 点击确定。用一张图来表示就是：
在这个过程中需要注意的问题是，添加PATH路径的时候，要在最后面添加一个分号。现在我们再次在浏览器里面输入“Python”，就能直接在控制台出入命令了：
第二步，我们安装pip。我们同样需要在Python的官网上去下载，下载地址是：https://pypi.python.org/pypi/pip#downloads ：
下载完成之后，解压到一个文件夹，用CMD控制台进入解压目录，输入：
python setup.py install
安装好之后，我们直接在命令行输入pip，同样会显示‘pip’不是内部命令，也不是可运行的程序。因为我们还没有添加环境变量。
按照之前介绍的添加环境变量的方法，我们在PATH最后添加：
C:\Python34\S
到现在我们才算完整安装好了pip：
第三步，安装一些Python的包，比如Tornado这个web框架：
到这里，整个安装教程就完成了，Enjoy yourself~
如果需要转载本文，请加上转载地址：/yuanzm/p/4089856.html，谢谢~
已发表评论数()
请填写推刊名
描述不能大于100个字符!
权限设置： 公开
仅自己可见
正文不准确
标题不准确
排版有问题
主题不准确
没有分页内容
图片无法显示
视频无法显示
与原文不一致