It is possible to disallow users from using old_passwords=1. This
can be done by adding 'maximum-old_passwords=0' to your
my.cnf
This prevents users from generating passwords hashes in pre-4.1
format. In MySQL 5.7 old_passwords=1 is already disabled, so this
is only useful on 5.6 and earlier.
Be aware that this also restricts old_passwords=2 which is needed
for sha256 hashes.
mysql> select @@old_passwords;[Read more]
+-----------------+
| @@old_passwords |
+-----------------+
| 0 |
+-----------------+
1 row in set (0.00 sec)
mysql> set old_passwords=1;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show warnings;
+---------+------+----------------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------------+
| …