无法使用Python3使用有效详细信息连接MySQL数据库

发布于 2025-02-01 23:48:58 字数 1640 浏览 4 评论 0原文

我已经使用了有效的详细信息与MySQL数据库连接,并且工作正常。但是,它突然引起了下面提到的错误。我已经尝试了解决问题的所有可能性。有人可以帮我吗?

预先感谢:-)

import mysql.connector.pooling

db_config = {
            'user' : 'root',
            'database' : 'persons_db',
            'host' : 'localhost',
            'password' : 'mypassword',
            'port' : 3306
        }

connection_pool = mysql.connector.pooling.MySQLConnectionPool(
    pool_name = "new_pool",
    pool_size = 10,
    auth_plugin='mysql_native_password',
    **db_config)


print(connection_pool)

输出:

Traceback (most recent call last):
  File "/home/vy/IDMP_Flask/sample_db_conn.py", line 11, in <module>
    connection_pool = mysql.connector.pooling.MySQLConnectionPool(
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/pooling.py", line 179, in __init__
    self.add_connection()
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/pooling.py", line 290, in add_connection
    cnx = Connect(**self._cnx_config)
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/__init__.py", line 272, in connect
    return CMySQLConnection(*args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/connection_cext.py", line 94, in __init__
    self.connect(**kwargs)
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/abstracts.py", line 1052, in connect
    self._open_connection()
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/connection_cext.py", line 246, in _open_connection
    self._cmysql.connect(**cnx_kwargs)
TypeError: function takes at most 24 keyword arguments (25 given)

I've used the valid details to connect with mysql database and it was working fine. But, it raising the below mentioned error all of sudden. I've tried all possibilities to solve the issue. Can someone please help me with this.

Thanks in advance :-)

import mysql.connector.pooling

db_config = {
            'user' : 'root',
            'database' : 'persons_db',
            'host' : 'localhost',
            'password' : 'mypassword',
            'port' : 3306
        }

connection_pool = mysql.connector.pooling.MySQLConnectionPool(
    pool_name = "new_pool",
    pool_size = 10,
    auth_plugin='mysql_native_password',
    **db_config)


print(connection_pool)

output:

Traceback (most recent call last):
  File "/home/vy/IDMP_Flask/sample_db_conn.py", line 11, in <module>
    connection_pool = mysql.connector.pooling.MySQLConnectionPool(
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/pooling.py", line 179, in __init__
    self.add_connection()
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/pooling.py", line 290, in add_connection
    cnx = Connect(**self._cnx_config)
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/__init__.py", line 272, in connect
    return CMySQLConnection(*args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/connection_cext.py", line 94, in __init__
    self.connect(**kwargs)
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/abstracts.py", line 1052, in connect
    self._open_connection()
  File "/usr/local/lib/python3.8/dist-packages/mysql/connector/connection_cext.py", line 246, in _open_connection
    self._cmysql.connect(**cnx_kwargs)
TypeError: function takes at most 24 keyword arguments (25 given)

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文