This problem can be solved by modifying variables.
Note: 8.0 is more variable with “. “than 5.7, so only half setting is not enough.
Note: 8.0 is more variable with “. “than 5.7, so only half setting is not enough.
Separately executed:
set global validate_password.policy=0;
set global validate_password.length=4;
Read More:
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- Linux (error 1819 (HY000): your password does not satisfy the current policy requirements)
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- Error (1820) if the password is not changed in time after MySQL installation
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- Setting the root password of windows 10 Ubuntu subsystem
- Error 1064 in MySQL password change
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- MySQL — initialize failed to generate temporary password in error log after initialization
- Centos7 forgot the root password and could not log in to the system
- Modify the password of mysql8 on Windows
- MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
- MySQL forgot the root password
- Clear the user name and password stored in GIT
- Cmake[Warning]:Policy CMP0054 is not set
- Unknown column ‘Password‘ in ‘field list‘
- Error loading password’s fault file (MySQL for Excel)
- Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in …