Reopen Mysql Connection in Python

Question

just wanna ask how do you reopen the connection after closing it?

i have this script

cursor.execute(add_data, dummy_data)
cnx = mysql.connector.connect(user='',
                                password ='',host='',
                              database='')
cursor = cnx.cursor()

add_data = insert statement
dummy_data = dictionary of data


cursor.execute(add_data, dummy_data)

cnx.commit()
cnx.close()

After inserting one set of values i cannot insert anymore.

This is the error : "OperationalError: 2055: Lost connection to MySQL server at system error 9: Bad file descriptor"

thanks in advance!

Normally, we close it after we've done all the inserts/updates/selects/... — xiaofeng.li
– xiaofeng.li, Commented Jan 6, 2015 at 1:59

Saher Ahwal · Accepted Answer · 2015-01-06 02:00:16Z

1

You need a new connection object after you close

cnx2 = mysql.connector.connect(user='',
                                password ='',host='',
                              database='')

but why would you close the connection? you should close the cursor and keep the connection open for all operations.

I would define an open connection function and a close connection function that I will call at begginning and end of program respectively.

answered Jan 6, 2015 at 2:00

Saher Ahwal

9,26733 gold badges91 silver badges156 bronze badges

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

3 Comments

ellaRT Over a year ago

but python doesnt have an open connection function unlike other languages, so i just need to declare a new one after closing the cursor?

Saher Ahwal Over a year ago

yes that is what I meant actually the connect function is the open

Saher Ahwal Over a year ago

you're welcome. If you think this answered your question well, please accept it and/or upvote. Thanks you!

Collectives™ on Stack Overflow

Reopen Mysql Connection in Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related