Re: Copy password from one user to another

[Georgi Kodinov]

Hi,

Note that mysql_native_password is deprecated since 8.0.34 and is turned off by default in 8.4. The intent is to have it removed some time in the future.

This is because it:
* uses a weak hash (SHA1) that is known to have conflicts.
* does not salt the passwords stored, so two users with the same password would have the same hash.

You have been exploiting the latter characteristics of it.

I would suggest that you consider using other means going forward.

Just curious: why would you need to do something like this?
Can you please share a bit more about your use case?

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria