所以这是我的sql im试图运行的(如果我能让它工作,请更改密码(
CREATE USER 'foxxything'@'192.168.100.%';
SET PASSWORD FOR 'foxxything'@'192.168.100.%' = '32$jV8klN2nGp2BmLuUb';
GRANT SELECT, INSERT, UPDATE, DELETE ON `foxxything`.* TO 'foxxything'@'192.168.100.%';
REVOKE REFERENCES, CREATE, DROP, ALTER, INDEX, TRIGGER ON `foxxything`.* FROM 'foxxything'@'192.168.100.%';
FLUSH PRIVILEGES;
这是密码策略的
validate_password.dictionary_file
validate_password.length 8
validate_password.mixed_case_count 1
validate_password.number_count 1
validate_password.policy MEDIUM
validate_password.special_char_count 1
然而它却犯了这样的错误。
您的密码不满足当前策略要求您的密码也不满足当前的策略要求
所以我不明白,任何帮助都是巨大的帮助!
创建用户时,它会在第一条sql语句上抛出错误。以这种方式创建用户会将密码设置为零,这违反了validate_password
设置。
相反,在使用IDENTIFIED BY
子句创建用户时指定密码:
CREATE USER 'foxxything'@'192.168.100.%' IDENTIFIED BY '32$jV8klN2nGp2BmLuUb';