python connect to mySql error-ConnectionRefusedError: [WinError 10061]

Question

I tried to connect mySql server, using python, this is my code(of course I changed the dataBase details to fake ones):

    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()

this program give this following error:

Traceback (most recent call last):
  File "C:\Users\user\AppData\Roaming\Python\Python34\site-packages\pymysql\connections.py", line 836, in connect
    (self.host, self.port), self.connect_timeout)
  File "C:\Python34\lib\socket.py", line 509, in create_connection
    raise err
  File "C:\Python34\lib\socket.py", line 500, in create_connection
    sock.connect(sa)
ConnectionRefusedError: [WinError 10061]

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:/Users/user/PycharmProjects/proj/projpy.py", line 432, in <module>
    db = "db_book")
  File "C:\Users\user\AppData\Roaming\Python\Python34\site-packages\pymysql\__init__.py", line 88, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\user\AppData\Roaming\Python\Python34\site-packages\pymysql\connections.py", line 657, in __init__
    self.connect()
  File "C:\Users\user\AppData\Roaming\Python\Python34\site-packages\pymysql\connections.py", line 882, in connect
    raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'blahblah.ipagemysql.com' ([WinError 10061] \u200f\u200f)")

any idea how to solve it?

sparrow · Accepted Answer · 2016-06-02 21:00:36Z

1

I was getting that same error until I included the "port" parameter which may be necessary for your server too?

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

answered Jun 2, 2016 at 21:00

sparrow

11.6k12 gold badges61 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MaxU - stand with Ukraine · Accepted Answer · 2016-02-01 20:41:46Z

0

check whether the "blahblah.ipagemysql.com" MySQL server is listening on localhost (127.0.0.1) and change it if necessary.

answered Feb 1, 2016 at 20:41

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

4 Comments

MaxU - stand with Ukraine Over a year ago

is it Linux or Windows or something else server? I mean: "blahblah.ipagemysql.com"

MaxU - stand with Ukraine Over a year ago

dev.mysql.com/doc/refman/5.7/en/option-files.html you may also try to check it, using telnet: [telnet blahblah.ipagemysql.com 3306], if MySQL is listening on the standard (3306) port...

jaldk Over a year ago

This is a my sql server from ipage.com. If this is what you meant

MaxU - stand with Ukraine Over a year ago

OK, does it work with the mysql client: [mysql --host=blahblah.ipagemysql.com --user=blah --password=1234 db_book] ? you should start that command from the same server/machine where you're starting your python program

Collectives™ on Stack Overflow

python connect to mySql error-ConnectionRefusedError: [WinError 10061]

2 Answers 2

Comments

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Related