con

conenction_string.py

# I have stored my credentials in a json file 
import json 
import pandas as pd 
import plotly.express as px
with open("creds.json","r") as f:
    creds = json.load(f)
# my username
user = creds['user']
# my password
password = creds['password']
# name of my database
database_name = 'order_factory'

# Defining A connection string and making a connection
########################################################################
%load_ext sql
connection_string = f"mysql://{user}:{password}@localhost/{database_name}"
%sql $connection_string
########################################################################