Python 3 pymysql Database Access - Connecting to Database getting following error

Question

Can anyone help me on this issue while connecting DB over the python 3.5. following error receiving.

import pymysql

# Open database connection
db = pymysql.connect("localhost","testuser","test123","TESTDB", )

# prepare a cursor object using cursor() method
cursor = db.cursor()

# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()")

# Fetch a single row using fetchone() method.
data = cursor.fetchone()

print ("Database version : %s " % data)

# disconnect from server
db.close()

Errors:

RESTART: C:/Program Files (x86)/Python35-32/db_connect.py Traceback (most recent call last): File "C:\Program Files (x86)\Python35-32\lib\site-packages\pymysql-0.7.11-py3.5.egg\pymysql\connections.py", line 916, in connect **kwargs) File "C:\Program Files (x86)\Python35-32\lib\socket.py", line 712, in create_connection raise err File "C:\Program Files (x86)\Python35-32\lib\socket.py", line 703, in create_connection sock.connect(sa) ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "C:/Program Files (x86)/Python35-32/db_connect.py", line 4, in db = pymysql.connect("localhost","testuser","test123","TESTDB", ) File "C:\Program Files (x86)\Python35-32\lib\site-packages\pymysql-0.7.11-py3.5.egg\pymysql__init__.py", line 90, in Connect return Connection(*args, **kwargs) File "C:\Program Files (x86)\Python35-32\lib\site-packages\pymysql-0.7.11-py3.5.egg\pymysql\connections.py", line 706, in __ init __ self.connect() File "C:\Program Files (x86)\Python35-32\lib\site-packages\pymysql-0.7.11-py3.5.egg\pymysql\connections.py", line 963, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([WinError 10061] No connection could be made because the target machine actively refused it)")

zglin · Accepted Answer · 2017-05-11 13:38:33Z

1

From the help

The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.

Check that you have mysql running and try connecting on the appropriate port (default is 3306)

answered May 11, 2017 at 13:38

zglin

2,9192 gold badges18 silver badges26 bronze badges

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

Comments

JayRizzo · Accepted Answer · 2018-08-30 02:35:50Z

0

Your issue might be the extra comma with nothing at the end of your connection string as posted in your statement.

"TESTDB", )

It also may help to use the port # even if its the default.

Explicit is better than implicit.

Update:

According to the Docs when you don't provide a port it defaults to 0 (at least that is how i am reading it. Please correct me if I am wrong.)

class pymysql.connections.Connection(host=None, user=.... port=0,

edited Aug 30, 2018 at 2:35

answered Aug 30, 2018 at 2:08

JayRizzo

3,6963 gold badges37 silver badges55 bronze badges

Collectives™ on Stack Overflow

Python 3 pymysql Database Access - Connecting to Database getting following error

2 Answers 2

Comments

Update:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Update:

Comments

Your Answer

Sign up or log in

Post as a guest

Related