mysql> SHOW VARIABLES LIKE 'old_passwords';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | 0 |
+---------------+-------+
ysql> SHOW GRANTS;
------------------------------------------------------------------------------------------------------------+
Grants for try@localhost |
------------------------------------------------------------------------------------------------------------+
GRANT USAGE ON *.* TO 'try'@'localhost' IDENTIFIED BY PASSWORD '*01E3DDAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA' |
GRANT ALL PRIVILEGES ON `try`.* TO 'try'@'localhost' |
------------------------------------------------------------------------------------------------------------+
The first query says whether old passwords are allow (0=no).
The second shows my encrypted password; it is a "new" password. If had been something like BY PASSWORD '012346789ABCDEF'
, it would be "old".
Old: 16 hex; New: '*' plus lots of hex.
Try it on yourself.