mysql获取用户权限api

SHOW GRANTS FOR 'username'@'host';

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='host', database='database')

# 创建游标
cursor = cnx.cursor()

# 执行查询
query = "SHOW GRANTS FOR %s@%s"
cursor.execute(query, ('username', 'host'))

# 获取结果
for grant in cursor:
    print(grant)

# 关闭连接
cursor.close()
cnx.close()

import mysql.connector

try:
    cnx = mysql.connector.connect(user='username', password='password',
                                  host='host', database='database')
    cursor = cnx.cursor()
    cursor.execute("SELECT * FROM sensitive_table")
    result = cursor.fetchall()
except mysql.connector.errors.OperationalError as err:
    if err.errno == 1045:
        print("Access denied for user")
    else:
        print("Other operational error:", err)
finally:
    cursor.close()
    cnx.close()