/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

1 vote127 views1 answer
Uninstall a python package from virtualenv
Python
1 vote132 views1 answer
Python index 2d array
Python
-2 votes122 views1 answer
Center buttons tkinter
Python
0 vote157 views1 answer
Mad scipy
Python
0 vote113 views1 answer
Python ssl module is not available
Python
5 votes125 views1 answer
Tkinter maximum window size
Python
0 vote127 views1 answer
Standard scaler vs min max scaler
Python
0 vote127 views1 answer
Return a tuple c++ python 3
Python
5 votes131 views4 answers
Binary to decimal python
Python
3 votes127 views3 answers
How to add header in csv file in python
Python