Differences
This shows you the differences between two versions of the page.
— | database:mysql:password [2021/03/11 10:22] (current) – created - external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== MySql password and old_password ====== | ||
+ | <code sql> | ||
+ | /* Old password type */ | ||
+ | SET PASSWORD FOR ' | ||
+ | /* New password type */ | ||
+ | SET PASSWORD FOR ' | ||
+ | ALTER USER ' | ||
+ | </ | ||
+ | < | ||
+ | SHOW VARIABLES LIKE ' | ||
+ | +--------------------------------------+-------+ | ||
+ | | Variable_name | ||
+ | +--------------------------------------+-------+ | ||
+ | | validate_password.check_user_name | ||
+ | | validate_password.dictionary_file | ||
+ | | validate_password.length | ||
+ | | validate_password.mixed_case_count | ||
+ | | validate_password.number_count | ||
+ | | validate_password.policy | ||
+ | | validate_password.special_char_count | 1 | | ||
+ | +--------------------------------------+-------+ | ||
+ | SET GLOBAL validate_password.length = 6; | ||
+ | SET GLOBAL validate_password.number_count = 0; | ||
+ | </ |