Is the MySQL PASSWORD function no longer valid?

[ginerjm]

Suddenly my old php code is having a problem when I try to run a mysql query that still uses the password function.  I know I am way out of date but this code was working fine until the last week or so.   Do I have some coding tasks ahead of me?

[requinix]

"A problem"?

[ginerjm]

   Yes - I know I am out of date and it is something I should have handled long ago.  That said - Is my question valid?  The PASSWORD function is no longer valid?

[Barand]

[ginerjm]

Guess I have some work to do.....

[gizmola]

On 12/15/2023 at 12:14 PM, ginerjm said:

Guess I have some work to do.....

I have a note that the reverse engineered underlying code that will work with 8.x is this:

SELECT CONCAT('*', UPPER(SHA1(UNHEX(SHA1('password')))));