mysql 查询账号密码

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

SELECT password FROM users WHERE username = 'admin';

SELECT password FROM users WHERE username = 'admin';

import hashlib

def decrypt_password(encrypted_password):
    # 这里假设使用SHA-256加密
    return hashlib.sha256(encrypted_password.encode()).hexdigest()

import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="mydatabase")
cursor = db.cursor()

username = "admin"
query = "SELECT password FROM users WHERE username = %s"
cursor.execute(query, (username,))
result = cursor.fetchone()

if result:
    password = result[0]
    print("Password:", password)
else:
    print("User not found")