query table with mysql.connector python to pandas datafrma code example

Example: mysql to df

import mysql.connector
import pandas as pd

db_connection = mysql.connector.connect(
  host="localhost",
  user="user",
  password="password",
  database="dbname",
  auth_plugin='mysql_native_password'
)

df = pd.read_sql("select * from table_name;", con=db_connection)
print(df)