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;