MySQL Error Message
SET PASSWORD has no significance for user ‘%s’@’%s’ as
the authentication method used doesn’t store authentication data
in the MySQL server. Please consider using ALTER USER instead if
you want to change authentication parameters.
Reason for the Error
ER_SET_PASSWORD_AUTH_PLUGIN_ERROR
was added in 8.0.29.