How can I connect to a database using PyMySQL?

Question

I am making a database manager in Python and I want the user to be able to select a database.

I know that one can connect to a database using the following code

connection = pymysql.connect(
    host='localhost'
    user='root'
    passwd=''
    db='my_database'
)

But what if the user wants to connect to a different database later on? How would I tell connection to connect to a different database? Or better yet, omit db and then add it later on.

you probably should close previously opened one and create another connection — Azat Ibrakov
– Azat Ibrakov, Commented Jun 1, 2017 at 14:44

saoili · Accepted Answer · 2017-06-01 14:21:41Z

2

Calling pymysql.connect actually creates the connection to the database. If you want to connect to a different database you should create a new connection object, rather than trying to reuse the same one. You could assign it to the same variable name if you wanted to 'reuse' it later in your code.

answered Jun 1, 2017 at 14:21

saoili

437 bronze badges

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

Comments

cardamom · Accepted Answer · 2017-06-01 14:27:06Z

1

Like this:

connection1 = pymysql.connect(
    host='localhost'
    user='root'
    passwd=''
    db='my_database'
)

connection2 = pymysql.connect(
    host=?
    user=?
    passwd=?
    db='my_other_database'
)

answered Jun 1, 2017 at 14:27

cardamom

7,51112 gold badges62 silver badges117 bronze badges

Comments

Clockwork · Accepted Answer · 2017-06-01 14:22:21Z

0

You can just do:

connection.close()

And then open another connection.

answered Jun 1, 2017 at 14:22

Clockwork

537 bronze badges

Collectives™ on Stack Overflow

How can I connect to a database using PyMySQL?

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related