|
本地连接远程数据库报10061错误,可是我用SSMS是可以连接上的,本地Mysql服务也启动了,就是不行呢。。求大神指教
代码:
import MySQLdb
import pymysql
db = MySQLdb.connect(
host="10.6.102.145",
user="******",
passwd="******",
db="XXXX",
charset="utf8"
)
cursor = db.cursor()
cursor.execute("SELECT * FROM dbo.APP_DB_GPRS_INFO limit 1")
data = cursor.fechone()
print (data)
执行错误码:
Traceback (most recent call last):
File "1.py", line 25, in <module>
charset="utf8"
File "C:\Users\tj201028\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\__init__.py", line 84, in Connect
return Connection(*args, **kwargs)
File "C:\Users\tj201028\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connecti**.py", line 164, in __init__
super(Connection, self).__init__(*args, **kwargs2)
MySQLdb._excepti**.OperationalError: (2002, "Can't connect to MySQL server on '10.6.102.145' (10061)")
|
|