/Python/Connect to mysql database jupyter

Connect to mysql database jupyter

# In the python cmd, install packages:
pip3 install pymysql
pip3 install ipython-sql
pip3 install mysqlclient

# in the jupyter notebook:
import pymysql
import pandas as pd

conn=pymysql.connect(host='localhost',port=int(3306),user='root',passwd='YOUR_PASSWORD',db='YOUR_DATABASENAME')

df=pd.read_sql_query("SELECT * FROM 'YOUR_TABLENAME' ",conn)

print(df)

Source: stackoverflow.com

How to connect mysql database in jupyter notebook

# %%
%load_ext sql

# %%
%sql mysql+mysqldb://<user>:<password>@localhost/<dataBase>

# %%
%%sql

SELECT *
FROM <table>;

Source: stackoverflow.com

Similar codes

0 vote204 views1 answer
?: (corsheaders.E013) Origin '.' in CORS_ORIGIN_WHITELIST is missing scheme or netloc HINT: Add a scheme (e.g. https://) or netloc (e.g. example.com).
Python
0 vote178 views1 answer
Python best docstring format
Python
0 vote176 views1 answer
Add favicon in django admin
Python
0 vote164 views1 answer
Markers are not visible on line plot
Python
0 vote173 views1 answer
Are angles of a parallelogram equal?
Python
0 vote159 views2 answers
Atoi in python code
Python
0 vote170 views1 answer
Writing Bytes to a File in python
Python
4 votes164 views1 answer
Get os information python
Python
158 votes189 views3 answers
Traversing dictionary in python
Python
0 vote164 views1 answer
Pygame get surface region
Python