Zabbix Database Error

[TheCookieMonster]

We lost power to our server room, and when the Zabbix Server came back up, when browsing to the frontend Zabbix page, we are presented with the error:
'Error connecting to database: The server requested authentication method unknown to the client'

Looking on the Zabbix Server, zabbix-server.log and zabbix-agentd.log show they are connected to the database fine, so it looks like it is just the frontend having problems.

We are using:
Ubuntu 18.04
MySQL 8.0.15
Zabbix 4.0.5

Can anyone help me understand how to investigate and fix this?

[max.ch.88]

What does mysql write in log? Do you can to do the manual connect between frontend and mysql?

[aravivek07]

Is there any solution for this? I'm getting the same error

• The server requested authentication method unknown to the client

• The server requested authentication method unknown to the client

[NgRox]

2 possible causes

When logging into Zabbix for the first time, you will be asked to enter the database connection details, you enter a complicated password and get the error "The server requested authentication method unknown to the client."

This is possibly due to the PHP front-end not being aware of MySQL's password hashing requirement. So you can change the Zabbix user in the database to use the mysql_native_password option.

Resolution:
Exec in your DB:
ALTER USER 'zabbix'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

Restart MySQL