from mysql.connector.connection import MySQLConnection
cnx = MySQLConnection(
user='MYNAME',
host='127.0.0.1',
database='MYDATABASE',
password='MYPASSWORD',
# 查看验证方式 SELECT user, host, plugin FROM mysql.user;
auth_plugin='mysql_native_password',
# WTF,我数据库排序规则居然是这个编码。。。
collation='utf8mb3_general_ci',
)
with cnx.cursor() as cur:
cur.execute("SELECT @@version")
res = cur.fetchone()
print(res[0])