Password Policy

[Tonny de Groot]

Hi,

i am asked to look in to the security of MySQL and adjust it to comply with the following rules :

Maximum Password Age: 90 Days
Minimum Password Length: 8 Characters
Password must use characters from at least three of the following four categories:
- uppercase characters (A through Z)
- lowercase characters (a through z)
- base 10 digits (0 through 9)
- non alphanumeric characters (e.g., !, $, #, %) except “:“,“&“ and “+“
Minimum Password Age: 1 Days
Password Uniqueness: Remember 12 Passwords
Account lockout:
- Lockout after 3 bad logon attempts
- Reset count after 30 minutes
- Lockout Duration: 15 minutes
Users must log on in order to change password: Not set on
Do NOT use common or proper nouns
Do NOT use your name or login name, even with digits
Do NOT use accentuated characters like é or ï (they are not allowed)

Can this be done.
i was thinking of making a trigger but it is not allowed on the MYSQL.User table;

Thx For the help.