4/28/2023 0 Comments Mysqladmin password strongpassword![]() # - you can add more policy commands each by your needs. Validate_password.policy = LOW # <= this line After Applying these changes with mysql Hung Nguyen answer.To make your policy configuration PERSISTENT, you should follow these instructions: (tested on ubuntu server version 20.10) This information is important to all answers above : When you restart mysql server all policy config will be RESET and will be LOST, so Then you can update your blank password using this query: ALTER USER IDENTIFIED WITH mysql_native_password BY '' | validate_password.special_char_count | 0 | | validate_password.mixed_case_count | 0 | | validate_password.check_user_name | ON | The output should be something like that : SHOW VARIABLES LIKE 'validate_password%' SET GLOBAL validate_password.special_char_count = 0 SET GLOBAL validate_password.policy = LOW SET GLOBAL validate_password.number_count = 0 ![]() SET GLOBAL validate_password.mixed_case_count = 0 SET GLOBAL validate_password.dictionary_file = '' Then running the following query in MySQL client: SET GLOBAL validate_password.check_user_name = No You can pick any combination as long as it satisfies the policy.įor other "validate_password_policy" you can simply look the values for different options and pick your password accordingly (I haven't tried for "STRONG"). Examples of valid password for above rules maybe: So a valid password must obey the policy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |