MySQL Error MY-011246 – ER_SHA_PWD_FAILED_TO_PARSE_AUTH_STRING

MySQL Error Message

Failed to parse stored authentication string for %s.
Please check if mysql.user table not corrupted

Reason for the Error

ER_SHA_PWD_FAILED_TO_PARSE_AUTH_STRING
was added in 8.0.4.