@ivange94 Thanks for the advice. I was able to resolve it by following the accepted answer to this question: https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
I believe this uses the legacy password plugin as mentioned in the answer. Please let me know if this a viable solution.
Thanks