How to use a Jupyter notebook to run MySQL Query?

Writing an SQL query in Jupyter Notebook when a connection to a database has been established involves a few steps. Here's a general outline of the process:

pip install mysql-connector-python

Update Code with Connection Details: Replace the placeholders in the code with your actual MySQL database connection details. Update the user, host, database, and
host='localhost',
user='root',
password = 'xxxxxxxx,
db='indra',
)

print(my_result)
# Disconnecting from the server

To run the provided code in a Jupyter Notebook, you can follow these steps:

Open Jupyter Notebook: Launch Jupyter Notebook by opening a terminal or command prompt and typing:
jupyter notebook
This will open the Jupyter Notebook interface in your web browser.

Create a New Notebook: In the Jupyter Notebook interface, click on the "New" button and select "Python 3" under "Notebooks" to create a new Python notebook.

Copy and Paste Code: In a notebook cell, copy and paste the provided code:
user='root',
host='localhost',
database='indra',
)
print(conn)

# Disconnecting from the server
Run the Code: To run the code in the cell, you can either press the "Run" button in the toolbar at the top of the notebook or press Shift+Enter after selecting the cell. The code will be executed, and if the connection details are correct, you will see the connection object printed as output.