/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 vote131 views1 answer
RuntimeError: input must have 3 dimensions, got 4 site:stackoverflow.com
Python
0 vote147 views1 answer
Pyqgis
Python
0 vote159 views1 answer
Python logging comma to dot
Python
7 votes161 views6 answers
Dictionary comprehension python
Python
3 votes149 views1 answer
Split string into array every n characters python
Python
1 vote148 views1 answer
Pandas write to csv without first line
Python
0 vote192 views1 answer
Get hash python
Python
0 vote152 views1 answer
Get question mark from a word + python
Python
0 vote157 views1 answer
Add an element to list python
Python
8 votes273 views3 answers
Add new column based on condition on some other column in pandas.
Python