MySQL-如何实现服务器端密码散列

-- 创建一个新用户并使用SHA-256散列密码
CREATE USER 'newuser'@'localhost' IDENTIFIED BY SHA2('mypassword', 256);

-- 或者更新现有用户的密码
ALTER USER 'existinguser'@'localhost' IDENTIFIED BY SHA2('newpassword', 256);

-- 设置全局密码策略
SET GLOBAL validate_password.policy = STRONG;

-- 或者为特定用户设置密码策略
ALTER USER 'user'@'host' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

-- 启用SSL/TLS
GRANT ALL PRIVILEGES ON *.* TO 'user'@'host' REQUIRE SSL;

-- 更新用户密码
ALTER USER 'user'@'host' IDENTIFIED BY 'newpassword';

-- 启用审计插件（如audit_log）
INSTALL PLUGIN audit_log SONAME 'audit_log.so';