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

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

python - How do I create a list index that loops through integers in another list -

c# - “System.Security.Cryptography.CryptographicException: Keyset does not exist” when reading private key from remote machine -