python3与mysql数据库连接方式

import mysql.connector

mydb = mysql.connector.connect(

host="192.168.1.196",  # 数据库主机地址

user="root",  # 数据库用户名

passwd="localsense"  # 数据库密码

)

mycursor = mydb.cursor()

sql = "INSERT INTO lssdrn.localsense_svrlog (id, username, address, type, module, result, timestamp, details) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)"

val = (a, "admin", "127.0.0.1", "login", "user", "success", time.time()*1000, "username:admin")

mycursor.execute(sql, val)

mydb.commit()

print(mycursor.rowcount, "记录插入成功。")