Data Analysis with SQL : How to Connect to MySQL in Jupyter Notebook

[@Sovan_Whistling]

Atlast, found it after 5days. Thank you.
Now I have to make it as a dataframe with the help of pandas.
Happy Coding!

[@epythonlab]

That's great to hear this sound. Keep learning 👍

[@__Mako]

Oh man i spent two hours+ trying to connect MySQL into Jupyter in my VS code studio IDE. I went through dozen of online articles, stack overflow, RUclips, ChatGPT, CodeWhisperer. But I found you with just a few line of codes I can connect my database and use magic SQL now. You're a G.

[@epythonlab]

Thanks for your feedback

[@ShivamSingh-nc8rq]

Thank you so much for making this video ❤. I've been trying to connect MySQL with Jupiter notebook from a very long time but I couldn't find proper video regarding this.

[@epythonlab]

Thanks for your feedback. Join t.me/epythonlab for more to learn

[@HamzahAbdulRahman]

Great video. Thanks a lot

[@epythonlab]

Thanks for your feedback.🙏

[@vaibhavchaudhary1569]

You are a genius!

[@epythonlab]

Thanks 👍

[@debasissahoo7559]

Thanks

[@epythonlab]

You are welcome. Share it to your networks

[@welcometooaudioland7877]

Thank you for posting, QUESTION : How do you hide your password ? Surely you wouldn't want the password visible within the note book correct?

[@epythonlab]

Ok. Good question. I will do hiding your password. Contact me telegram.me/asibehtenager

[@bagdaybi]

Sorry Mr, but how do we know our db_name ? because when I try to fix it, it still error? I have no idea why

[@epythonlab]

Ask t.me/[e-mail] on Telegram.

[@henrydeutsch5130]

no attached jupyter notebook?

[@epythonlab]

You can ask notebook at t.me/epythonlab

[@uanuu800]

# import必要包
from sqlalchemy import create_engine,Table,Column,Integer,String,MetaData,ForeignKey
# 创建连接引擎
engine = create_engine("mysql+pymysql://用户名:密码@主机名:端口号/数据库名",echo=True)
# 查询表数据
query = '''
SELECT * FROM Products
'''
df = pd.read_sql_query(query, engine)
df