Connecting Python notebook to MySQL Database

Question

How can I connect a MySQL database to my Jupyter notebook to execute queries using Python notebook?

My code:

import pymysql
conn = MySQLdb.connect(host=dsn_hostname, port=dsn_port, user=dsn_uid, passwd=dsn_pwd, db=dsn_database)

After establishing connection how can I start executing queries?

"After I connect how can I connect?" What?

tadman
– tadman

2017-11-14 17:20:05 +00:00
Commented Nov 14, 2017 at 17:20 — tadman
– tadman, Commented Nov 14, 2017 at 17:20
Sorry. Edited the question

Hello.World
– Hello.World

2017-11-14 17:20:59 +00:00
Commented Nov 14, 2017 at 17:20 — Hello.World
– Hello.World, Commented Nov 14, 2017 at 17:20
please check this answer

Foad S. Farimani
– Foad S. Farimani

2020-03-28 01:24:34 +00:00
Commented Mar 28, 2020 at 1:24 — Foad S. Farimani
– Foad S. Farimani, Commented Mar 28, 2020 at 1:24

nikhilkarn · Accepted Answer · 2020-08-06 06:50:02Z

0

import pymysql.cursorsenter 
connection = pymysql.connect(host='localhost',
                         user='user_name',
                         password='password',
                         db='name_of_database',
                         charset='utf8mb4',
                         cursorclass=pymysql.cursors.DictCursor)

answered Aug 6, 2020 at 6:50

nikhilkarn

1

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

Collectives™ on Stack Overflow

Connecting Python notebook to MySQL Database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related