无法使用Python3使用有效详细信息连接MySQL数据库
我已经使用了有效的详细信息与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 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论