getting error in logs -Unable to connect databasse in zabbix 5.0

[Siddhesh]

Hi Team,
I'm New to zabbix.
I have configured zabbix 5.0 on RHEL 7 as described on https://www.zabbix.com/download?zabb...ysql&ws=apache .
.
but i'm getting below error

66168:20200529:172424.176 using configuration file: /etc/zabbix/zabbix_server.conf
66168:20200529:172424.178 [Z3001] connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
66168:20200529:172424.178 Cannot connect to the database. Exiting...
66175:20200529:172434.423 Starting Zabbix Server. Zabbix 5.0.0 (revision 9665d62db0).

Kindly help me

[tim.mooney]

This problem isn't specific to Zabbix. Try doing a web search using your favorite search engine and the error message

Authentication plugin 'caching_sha2_password' cannot be loaded

The basic problem is that recent versions of MySQL/MariaDB/Percona have added support for more advanced authentication methods, using plugins.

Whatever database and database version you're using (hint: including that information in a question may help people that are trying to answer your question) is defaulting to using a newer authentication or encryption method for the 'zabbix' user, but the plugin needed is not installed.

The easiest solution is to change the 'zabbix' database user to use the older style encryption method. If you do the web search and look through some of the results, there will be examples of how to alter the user to use the mysql_native_password .