PASSWORD() function used on 8.0

[fmonts]

I'm on a Percona Server for MySQL 8.0.40.
When running mysqltuner, I got a lot of errors in the output due to the fact that it's using the PASSWORD() function, which has been removed in MySQL 8:

MySQLTuner 2.6.2
[...]
✔ Currently running supported MySQL version 8.0.40
[...]
ℹ There are 620 basic passwords in the list.
✘ Failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE password = PASSWORD('1') OR password = PASSWORD(UPPER('1')) OR password = PASSWORD(CONCAT(UPPER(LEFT('1', 1)), SUBSTRING('1', 2, LENGTH('1'))))
✘ FAIL Execute SQL / return code: 256
✘ Failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE password = PASSWORD('123456') OR password = PASSWORD(UPPER('123456')) OR password = PASSWORD(CONCAT(UPPER(LEFT('123456', 1)), SUBSTRING('123456', 2, LENGTH('123456'))))
✘ FAIL Execute SQL / return code: 256
[...]

This is happening only on 2.6.2, while 2.6.1 didn't show the errors (I'm not sure if it's a regression or they were just silenced)

For those having the same issue, you can delete the basic_passwords.txt file to get rid of them.

[simonhampel]

I can confirm the same issue here - MySQL 8.0.40 and MySQLTuner 2.6.2 gives the same errors while 2.6.1 does not.