Show pageOld revisionsBacklinksExport to PDFBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== MySql password and old_password ====== <code sql> /* Old password type */ SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass'); /* New password type */ SET PASSWORD FOR 'some_user'@'some_host' = PASSWORD('mypass'); ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypass'; </code> <code> SHOW VARIABLES LIKE 'validate_password%'; +--------------------------------------+-------+ | Variable_name | Value | +--------------------------------------+-------+ | validate_password.check_user_name | ON | | validate_password.dictionary_file | | | validate_password.length | 6 | | validate_password.mixed_case_count | 1 | | validate_password.number_count | 1 | | validate_password.policy | LOW | | validate_password.special_char_count | 1 | +--------------------------------------+-------+ SET GLOBAL validate_password.length = 6; SET GLOBAL validate_password.number_count = 0; </code> database/mysql/password.txt Last modified: 2021/03/11 10:22by 127.0.0.1