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

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

SVG stroke-linecap doesn't work for circles in Firefox? -

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -