//Python libreria
import mysql.connector as mysql

Objeto:
db = mysql.connect(host="192.168.1.6", user="roger",passwd="1234",database="test")

//instalar el mysql-connector en python3
pip3 install mysql-connector-python

//Funciones
cursor = db.cursor()
cursor.execute(query)
cursor.exectute(query,valores)

//envio del query
db.commit()