欢迎各位兄弟 发布技术文章

这里的技术是共享的

You are here

ImportError: No module named mysql.connector linux 安装mysql驱动有大用

shiping1 的头像
明明已经安装 Mysql-python 了,却依然报这个错误。

[root@scmroad controller]# python controller.py
Traceback (most recent call last):
  File "controller.py", line 20, in <module>
    from Mysql import MySql
  File "/apps/var/app1/controller/Mysql.py", line 1, in <module>
    import mysql.connector
ImportError: No module named mysql.connector
[root@scmroad controller]#

下面是 MySQL-Python 的安装过程
[root@scmroad MySQL-python-1.2.5]# pwd
/root/soft/MySQL-python-1.2.5
[root@scmroad MySQL-python-1.2.5]# chmod +x setup.py
[root@scmroad MySQL-python-1.2.5]# python setup.py install
Copying MySQL_python-1.2.5-py2.7-linux-x86_64.egg to /apps/usr/python/lib/python2.7/site-packages
MySQL-python 1.2.5 is already the active version in easy-install.pth
.......
Installed /apps/usr/python/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg
Processing dependencies for MySQL-python==1.2.5
Finished processing dependencies for MySQL-python==1.2.5
[root@scmroad ~]# python
Python 2.7.2 (default, Jul 10 2014, 11:19:41)
[GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named mysql.connector
>>>

这个包也的确在python 的site-package 下面

[root@scmroad ~]# python -v
# installing zipimport hook
import zipimport # builtin
# installed zipimport hook
# /apps/usr/python/lib/python2.7/site.pyc matches /apps/usr/python/lib/python2.7/site.py
import site # precompiled from /apps/usr/python/lib/python2.7/site.pyc
# /apps/usr/python/lib/python2.7/os.pyc matches /apps/usr/python/lib/python2.7/os.py
import os # precompiled from /apps/usr/python/lib/python2.7/os.pyc
import errno # builtin
import posix # builtin
# /apps/usr/python/lib/python2.7/posixpath.pyc matches /apps/usr/python/lib/python2.7/posixpath.py
import posixpath # precompiled from /apps/usr/python/lib/python2.7/posixpath.pyc
# /apps/usr/python/lib/python2.7/stat.pyc matches /apps/usr/python/lib/python2.7/stat.py
import stat # precompiled from /apps/usr/python/lib/python2.7/stat.pyc
# /apps/usr/python/lib/python2.7/genericpath.pyc matches /apps/usr/python/lib/python2.7/genericpath.py
import genericpath # precompiled from /apps/usr/python/lib/python2.7/genericpath.pyc
# /apps/usr/python/lib/python2.7/warnings.pyc matches /apps/usr/python/lib/python2.7/warnings.py
import warnings # precompiled from /apps/usr/python/lib/python2.7/warnings.pyc
# /apps/usr/python/lib/python2.7/linecache.pyc matches /apps/usr/python/lib/python2.7/linecache.py
import linecache # precompiled from /apps/usr/python/lib/python2.7/linecache.pyc
# /apps/usr/python/lib/python2.7/types.pyc matches /apps/usr/python/lib/python2.7/types.py
import types # precompiled from /apps/usr/python/lib/python2.7/types.pyc
# /apps/usr/python/lib/python2.7/UserDict.pyc matches /apps/usr/python/lib/python2.7/UserDict.py
import UserDict # precompiled from /apps/usr/python/lib/python2.7/UserDict.pyc
# /apps/usr/python/lib/python2.7/_abcoll.pyc matches /apps/usr/python/lib/python2.7/_abcoll.py
import _abcoll # precompiled from /apps/usr/python/lib/python2.7/_abcoll.pyc
# /apps/usr/python/lib/python2.7/abc.pyc matches /apps/usr/python/lib/python2.7/abc.py
import abc # precompiled from /apps/usr/python/lib/python2.7/abc.pyc
# /apps/usr/python/lib/python2.7/_weakrefset.pyc matches /apps/usr/python/lib/python2.7/_weakrefset.py
import _weakrefset # precompiled from /apps/usr/python/lib/python2.7/_weakrefset.pyc
import _weakref # builtin
# /apps/usr/python/lib/python2.7/copy_reg.pyc matches /apps/usr/python/lib/python2.7/copy_reg.py
import copy_reg # precompiled from /apps/usr/python/lib/python2.7/copy_reg.pyc
# /apps/usr/python/lib/python2.7/traceback.pyc matches /apps/usr/python/lib/python2.7/traceback.py
import traceback # precompiled from /apps/usr/python/lib/python2.7/traceback.pyc
# /apps/usr/python/lib/python2.7/sysconfig.pyc matches /apps/usr/python/lib/python2.7/sysconfig.py
import sysconfig # precompiled from /apps/usr/python/lib/python2.7/sysconfig.pyc
# /apps/usr/python/lib/python2.7/re.pyc matches /apps/usr/python/lib/python2.7/re.py
import re # precompiled from /apps/usr/python/lib/python2.7/re.pyc
# /apps/usr/python/lib/python2.7/sre_compile.pyc matches /apps/usr/python/lib/python2.7/sre_compile.py
import sre_compile # precompiled from /apps/usr/python/lib/python2.7/sre_compile.pyc
import _sre # builtin
# /apps/usr/python/lib/python2.7/sre_parse.pyc matches /apps/usr/python/lib/python2.7/sre_parse.py
import sre_parse # precompiled from /apps/usr/python/lib/python2.7/sre_parse.pyc
# /apps/usr/python/lib/python2.7/sre_constants.pyc matches /apps/usr/python/lib/python2.7/sre_constants.py
import sre_constants # precompiled from /apps/usr/python/lib/python2.7/sre_constants.pyc
# zipimport: found 78 names in /apps/usr/python/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg
# zipimport: found 94 names in /apps/usr/python/lib/python2.7/site-packages/pymongo-2.7.1-py2.7-linux-x86_64.egg
# zipimport: found 37 names in /apps/usr/python/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg
# zipimport: found 170 names in /apps/usr/python/lib/python2.7/site-packages/suds-0.4-py2.7.egg
# zipimport: found 82 names in /apps/usr/python/lib/python2.7/site-packages/paramiko-1.14.0-py2.7.egg
# zipimport: found 29 names in /apps/usr/python/lib/python2.7/site-packages/ecdsa-0.11-py2.7.egg
# zipimport: found 299 names in /apps/usr/python/lib/python2.7/site-packages/pycrypto-2.6.1-py2.7-linux-x86_64.egg
import encodings # directory /apps/usr/python/lib/python2.7/encodings
# /apps/usr/python/lib/python2.7/encodings/__init__.pyc matches /apps/usr/python/lib/python2.7/encodings/__init__.py
import encodings # precompiled from /apps/usr/python/lib/python2.7/encodings/__init__.pyc
# /apps/usr/python/lib/python2.7/codecs.pyc matches /apps/usr/python/lib/python2.7/codecs.py
import codecs # precompiled from /apps/usr/python/lib/python2.7/codecs.pyc
import _codecs # builtin
# /apps/usr/python/lib/python2.7/encodings/aliases.pyc matches /apps/usr/python/lib/python2.7/encodings/aliases.py
import encodings.aliases # precompiled from /apps/usr/python/lib/python2.7/encodings/aliases.pyc
# /apps/usr/python/lib/python2.7/encodings/utf_8.pyc matches /apps/usr/python/lib/python2.7/encodings/utf_8.py
import encodings.utf_8 # precompiled from /apps/usr/python/lib/python2.7/encodings/utf_8.pyc
Python 2.7.2 (default, Jul 10 2014, 11:19:41)
[GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> ^C
KeyboardInterrupt
>>>

 
收藏使用python 连接 mysql 有两个库,一个是 mysql-python ;另外一个是 mysql-connector
使用的时候要区分开。使用哪个安装哪个。


安装Connector/Python:
# wget http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-1.0.11.zip
# unzip mysql-connector-python-1.0.11.zip
# cd mysql-connector-python-1.0.11
# python setup.py install

测试是否安装成功

[root@scmroad ~]# python
Python 2.7.2 (default, Jul 10 2014, 11:19:41)
[GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector
>>>
普通分类: