Write the steps required to read data from a MySQL database to a DataFrame.

Q. Write the steps required to read data from a MySQL database to a DataFrame.

Answer :-

import mysql.connector as a
db=a.connect(user='root',passwd='0000000000' ,host='localhost',database='h')
import pandas as pd
df=pd.read_sql(f'select * from table_name',db)
print(df)