时间戳

首页 > 解决方案 > mysql-connector 的导入语句在 python 中不起作用

python - mysql-connector 的导入语句在 python 中不起作用

问题描述

此导入语句不起作用并且有错误。

import mysql.connector as mc

我没有在我的文件中使用任何日期时间函数，但它显示了这些错误。我哪里出错了？

Traceback (most recent call last):
  File "C:\Users\mg kaung sat\combo.py", line 9, in <module>
    import mysql.connector as mc
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\__init__.py", line 42, in <module>
    import dns.resolver
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\dns\resolver.py", line 38, in <module>
    import dns.query
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\dns\query.py", line 42, in <module>
    import requests
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\requests\__init__.py", line 43, in <module>
    import urllib3
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\urllib3\__init__.py", line 11, in <module>
    from . import exceptions
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\urllib3\exceptions.py", line 3, in <module>
    from .packages.six.moves.http_client import IncompleteRead as httplib_IncompleteRead
  File "<frozen importlib._bootstrap>", line 983, in _find_and_load
  File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 670, in _load_unlocked
  File "<frozen importlib._bootstrap>", line 583, in module_from_spec
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\urllib3\packages\six.py", line 234, in create_module
    return self.load_module(spec.name)
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\urllib3\packages\six.py", line 209, in load_module
    mod = mod._resolve()
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\urllib3\packages\six.py", line 118, in _resolve
    return _import_module(self.mod)
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\site-packages\urllib3\packages\six.py", line 87, in _import_module
    __import__(name)
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\http\client.py", line 71, in <module>
    import email.parser
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\email\parser.py", line 12, in <module>
    from email.feedparser import FeedParser, BytesFeedParser
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\email\feedparser.py", line 27, in <module>
    from email._policybase import compat32
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\email\_policybase.py", line 9, in <module>
    from email.utils import _has_surrogates
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\email\utils.py", line 33, in <module>
    from email._parseaddr import quote
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\email\_parseaddr.py", line 16, in <module>
    import time, calendar
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\calendar.py", line 50, in <module>
    class _localized_month:
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\calendar.py", line 52, in _localized_month
    _months = [datetime.date(2001, i+1, 1).strftime for i in range(12)]
  File "C:\Users\mg kaung sat\AppData\Local\Programs\Python\Python37\lib\calendar.py", line 52, in <listcomp>
    _months = [datetime.date(2001, i+1, 1).strftime for i in range(12)]
AttributeError: AttributeError: module 'datetime' has no attribute 'date'

标签： pythonmysql

解决方案

重击：$ python3 -m pip install mysql-connector
视窗：PS pip install mysql-connector

蟒蛇代码：db = mysql.connector.connect(host="host_name/IP", user="username", password="password", database="database_name", auth_plugin="mysql_native_password") c = db.cursor()

推荐阅读