我正在尝试将MySQLdb连接到MySQL。当我的服务器是本地主机和端口80时,它工作得很好。但由于某种原因我不得不把端口改成8080。现在如何在connect命令中指定端口?
这是我之前用过的:
db = MySQLdb.connect(host = "localhost", user = "root", passwd = "", db = "pymysql")
现在我的服务器是“localhost:8080”。那么我应该在哪里提供关于这个港口的信息呢? 我试过这个:
db = MySQLdb.connect(host = "127.0.0.1:8080", user = "root", passwd = "", db = "pymysql")
这就是我得到的:
Traceback (most recent call last):
File "<pyshell#4>", line 1, in <module>
db = MySQLdb.connect(host = "127.0.0.1:8080", user = "root", passwd = "", db = "pymysql")
File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2005, "Unknown MySQL server host '127.0.0.1:8080' (11004)")
请帮忙!!!
你应该读一下documentation。
端口8080或80通常用于非MySQL的web服务器
MySQL的默认端口是3306
相关问题 更多 >
编程相关推荐