python连接到mySql errorConnectionRefusedError:[WinError 10061]

Question

我试着用python连接mySql服务器，这是我的代码（当然我把数据库的细节改成了假的）：

    import pymysql
    connMySql= pymysql.connect (
    host = "blahblah.ipagemysql.com",
    user = "blah",
    passwd = "1234",
    db = "db_book")

    cur = connMySql.cursor()
    print ("writing to db")
    connMySql.commit()

此程序给出以下错误：

^{pr2}$

你知道怎么解决吗？在

Answer 1

我也遇到了同样的错误，直到我包含了“port”参数，这可能对您的服务器也是必要的？在

connection = pymysql.connect(host = host,
                       user = user,
                       db = db,
                       password = password,
                        port = port)

Answer 2

检查blahblah.ipagemysql.com网站“MySQL服务器正在监听localhost（127.0.0.1）并在必要时更改它。在