python连接数据库测试

pip install mysql-connector

import mysql.connector

mydb = mysql.connector.connect(
    host="127.0.0.1",
    user="root",
    passwd="123456"
)

cursor = mydb.cursor()
cursor.execute("show databases")

for x in cursor:
    print(x)

或者查询某表：

import mysql.connector

mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="123456"
)

cursor = mydb.cursor()

cursor.execute("use education")
cursor.execute("select * from sys_user limit 5")

for x in cursor:
    print(x)