Install a MySQL connector package:
`pip install mysql-connector-python`
or `pip install pymysql`
Import the package:
`import mysql.connector`
or `import pymysql`
Create a connection:
`conn = mysql.connector.connect(host=”localhost”, user=”root”, password=”your_password”, database=”your_db”)`
Create a cursor:
`cursor = conn.cursor()`
Execute a query:
`cursor.execute(“SELECT * FROM your_table”)`
Fetch results:
`rows = cursor.fetchall()`
Commit changes for INSERT, UPDATE, or DELETE:
`conn.commit()`
Close the cursor and connection:
`cursor.close()`
`conn.close()`
Example with `mysql-connector-python`:
`import mysql.connector`
`conn = mysql.connector.connect(host=”localhost”, user=”root”, password=”your_password”, database=”your_db”)`
`cursor = conn.cursor()`
`cursor.execute(“SELECT * FROM your_table”)`
`print(cursor.fetchall())`
`cursor.close()`
`conn.close()`