Are you encountering the frustrating Authentication plugin ‘caching_sha2_password’ cannot be loaded error when trying to connect…

Resolving the MySQL Error: ‘caching_sha2_password’ Authentication Plugin Issue
Are you encountering the frustrating Authentication plugin ‘caching_sha2_password’ cannot be loaded error when trying to connect…