mysql新建用户的时候出现

-- 确保当前用户具有足够的权限
SHOW GRANTS FOR CURRENT_USER;

-- 检查用户名是否已存在
SELECT User FROM mysql.user WHERE User = 'newuser';

-- 创建新用户
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

-- 授予权限
GRANT SELECT, INSERT ON mydatabase.* TO 'newuser'@'localhost';

-- 刷新权限
FLUSH PRIVILEGES;

-- 查看密码策略
SHOW VARIABLES LIKE 'validate_password%';

-- 修改密码策略（示例）
SET GLOBAL validate_password.policy = LOW;

-- 重新创建用户并设置密码
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpassword';

-- 允许远程连接（示例）
ALTER USER 'newuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';
FLUSH PRIVILEGES;

-- 检查防火墙设置，确保允许MySQL端口（默认3306）的连接