python操作MySQLdb报错

Question

问题遇到的现象和发生背景

import MySQLdb as mysql

c = mysql.connect(host="192.168.4.169", port="23306", user='root', passwd="bcat123456", database="bcat_csp", charset="utf8")
报错信息
- 
```python
Traceback (most recent call last):
  File "E:\pythonProject1\Mapptest\DXmapp\accessToken.py", line 47, in <module>
    c = mysql.connect(host="192.168.4.169", port="23306", user='root', passwd="bcat123456", database="bcat_csp", charset="utf8")
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python39\lib\site-packages\MySQLdb\__init__.py", line 123, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python39\lib\site-packages\MySQLdb\connections.py", line 185, in __init__
    super().__init__(*args, **kwargs2)
TypeError: an integer is required (got type str)

求解

操作环境、软件版本等信息

尝试过的解决方法

我想要达到的结果

Answer 1

你端口参数port要改为整型，不能是字符串，改为下面代码试试

c = mysql.connect(host="192.168.4.169", port=23306, user='root', passwd="bcat123456", database="bcat_csp", charset="utf8")