Problem

After migration to MySQL version 8.0, started getting a lot of messages like this in the MySQL log file:

[Warning] [MY-013360] [Server] Plugin mysql_native_password reported: 'mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

If the mysql_native_password is changed to caching_sha2_password, Jira won't work (fails to connect to the database)

Suggested Solution

—

Why This Is Important

Since MySQL will deprecate mysql_native_password shortly and Jira works with that only, support for caching_sha2_password must be added

Workaround

Leave as mysql_native_password and change MySQL log level to avoid receiving those warnings.