database - create a six character password in mysql 5.7 -
i need create user 6 character password in new mysql on mac. know lowest setting in 5.7 allows 8 characters. there anyway go around that?
i type in create user 'newsier'@'localhost' identified 'special'
it out puts error
error 1819 (hy000): password not satisfy current policy requirements
you using password validation plugin. default allows 8 characters , longer passwords. because can't check value of hash, @riggsfolly correct pre-hashing password work.
however, if want change options, you'll need set value of validate_password_length
system variable. can in configuration file or:
set global validate_password_length=6;
Comments
Post a Comment