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?

please check this [answer](https://stackoverflow.com/a/60896206/4999991) — Foad S. Farimani, Mar 28 '20 at 01:24

score 1 · Accepted Answer · answered Nov 14 '17 at 17:24

1

It's all written in the documentation: https://pymysql.readthedocs.io/en/latest/user/examples.html

answered Nov 14 '17 at 17:24

M. Matt

77
1
6

score 0 · Answer 2 · answered Aug 06 '20 at 06:50

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

Connecting Python notebook to MySQL Database

2 Answers2