after set zabbix db user password, aborted connections counter starts groing

[Gutsycat]

Very simple but not clear why.

set password for zabbix user:

SET PASSWORD FOR 'zabbix'@'localhost' = PASSWORD('mysupersecurepass');
Query OK, 0 rows affected (0.00 sec)

FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

also

nano zabbix.conf.php

$DB['USER']  = 'zabbix';
$DB['PASSWORD'] = 'mysupersecurepass';

nano zabbix_server.conf

DBUser=zabbix
DBPassword=mysupersecurepass

and
Aborted connections starts growing

Aborted connections: 1.91%  (415/21752)

What's wrong?

[kloczek]

Check access to the database using mysql command.

[Gutsycat]

Check access to the database using mysql command.

Works fine

# mysql -uzabbix -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 12345
Server version: 10.1.18-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use zabbix
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [zabbix]>

Should I change something here? /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

[kloczek]

You have been using test mysql command over localhost and password is setup as well for 'zabbix'@'localhost' .
Did zabbix web server running zabbix web frontend app and zabbix server are running on the same host?

[Gutsycat]

You have been using test mysql command over localhost and password is setup as well for 'zabbix'@'localhost' .
Did zabbix web server running zabbix web frontend app and zabbix server are running on the same host?

Did you mean this?

DBHost=localhost

[Atsushi]

If you are using userparameter_mysql.conf to acquire the metrics of MySQL server, have you created .my.cnf in the zabbix user's home directory and written authentication information?

[Gutsycat]

If you are using userparameter_mysql.conf to acquire the metrics of MySQL server, have you created .my.cnf in the zabbix user's home directory and written authentication information?

Sorry, what does it mean "zabbix user's home directory". Zabbix starts from root account.

[Atsushi]

What are you starting up by root?
Is execution command execution?
Or are you changing Zabbix agent settings so that Zabbix agent runs as root user?

If you are using the settings in userparameter_mysql.conf via the Zabbix agent, check the home directory of the user who is running the Zabbix agent.

[Gutsycat]

I checked "check the home directory of the user who is running the Zabbix agent. " and this user is "zabbix". So I've added .my.cnf file to user home directory with [client]\nuser=zabbix\npassword=mysupersecurepass. But again - same behavior. Any help wold be very appreciated.