This article shows how the open‑source Passay library replaces hand‑written password regex with a unified, extensible rule set, covering dependency setup, rule definitions, custom messages, N‑of‑M character requirements, history checks, and password generation, all demonstrated with runnable Java code.
The article analyzes a MySQL 5.7 replication failure where the slave SQL thread stops with error 1590 because the master writes an INCIDENT_EVENT to the binlog when a GRANT or CREATE USER statement partially succeeds due to password‑validation plugin constraints, leading to replication breakage.
MySQL 8.0.34 adds the validate_password.changed_characters_percentage variable, allowing administrators to require a minimum percentage of different characters when users change passwords, and the article demonstrates how to enable the policy, set up a test environment, and verify behavior with various password change scenarios.
This article introduces regular expressions through a Java password‑validation case, compares a manual character‑checking implementation with a concise regex solution, explains regex syntax and meta‑characters, and demonstrates how to apply Pattern.matches for string validation in Java.
