Python : How to create mysql databases with PyMySQL?

Question

I am using python 3.6, and I use PyMySQL to connect mysql.

I will create several databases. I want to write a Python script to do this for easily creating and removing them.

There is an example in PyMySQL docs with a piece of code like this:
PyMySQL docs ：https://pymysql.readthedocs.io/en/latest/user/examples.html

connection = pymysql.connect(host='localhost',
                             user='user',
                             password='passwd',
                             db='db',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

In the code above, the database already exists.

Now there are no databases in mysql. I want to create them via python and PyMySQL. What should I do?

Thomas Munk · Accepted Answer · 2020-07-29 12:30:45Z

16

Just leave out db:

conn = pymysql.connect(host='localhost',
                       user='user',
                       password='passwd')

Then get a cursor and create a database:

conn.cursor().execute('create database dbname')

Create a table in the new database:

conn.cursor().execute('create table dbname.tablename (...)')

edited Jul 29, 2020 at 12:30

answered Sep 5, 2017 at 13:07

Thomas Munk

7536 silver badges26 bronze badges

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

1 Comment

Давид Шико Over a year ago

You also must add this line. connection.select_db(DB_NAME)

Collectives™ on Stack Overflow

Python : How to create mysql databases with PyMySQL?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related