79605

er_not_valid_password [4252] error). This affectsthe create user, GRANT, and SET

password statements. Passwords given as arguments to the

PASS WORD () [1283] and

old_password () [1283] functions are checked as well.

•    The strength of potential passwords can be assessed using the new vali date_password_strength () [1285] SQL function, which takes a password argument

and returns an integer from 0 (weak) to 100 (strong).

Both capabilities are implemented by the validate_password plugin. For morę information, see

Section 6.1.2.6, “The Password Validation Plugin”.

•    mysąl upgrade now produces a warning if it finds user accounts with passwords hashed

with the older pre-4.1 hashing method. Such accounts should be updated to use morę secure

password hashing. See Section 6.1.2.4, “Password Hashing in MySQL”

•    On Unix platforms, mysql install db supports a new option, —

random-passwords [247],

that provides for morę secure MySQL installation. lnvoking

mysql_install_db with --random