Jump to content

Is the MySQL PASSWORD function no longer valid?


Go to solution Solved by Barand,

Recommended Posts

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?

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

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

Expand  

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')))));

 

  • Like 1
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.