Python mysql.connector AttributeError

Question

我在macOS High Sierra上使用Python3.6和mysql-connector2.1.6。当我尝试创建一个连接池时，按照文档页面'https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-constructor.html‘上的示例中的说明进行操作，如下所示：

cnxpool = mysql.connector.pooling.MySQLConnectionPool(pool_name = "mypool",pool_size = 3,**dbconfig)

我得到以下错误：

Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/IPython/core/interactiveshell.py", line 2869, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)
  File "<ipython-input-4-b07112a83246>", line 1, in <module>
    cnxpool = mysql.connector.pooling.MySQLConnectionPool(pool_name = "mypool",pool_size = 3,\**dbconfig)
AttributeError: module 'mysql.connector' has no attribute 'pooling'**

我已经提供了一个有效的**dbconfig参数。

有人能帮我解释一下为什么它不工作吗？

Answer 1

您必须使用此行代码导入池。

import mysql.connector.pooling