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)
求解
你端口参数port要改为整型,不能是字符串,改为下面代码试试
c = mysql.connect(host="192.168.4.169", port=23306, user='root', passwd="bcat123456", database="bcat_csp", charset="utf8")
端口是int类型,而且是3306不是23306
c = mysql.connect(host="192.168.4.169", port=3306, user='root', passwd="bcat123456", database="bcat_csp", charset="utf8")