создаю базу, пользователя даю права.
mysql> create database zabbix_db character set utf8 collate utf8_bin
-> create user 'zabbix_us'@'localhost' IDENTIFIED BY 'zabbix_pw'
-> grant all privileges on zabbix_db.* to zabbix_us@localhost identified by 'zabbix_pw'
-> \q
Bye
Проверяю
mysql -u zabbix_us -h localhost -p
Enter password:
ERROR 1045 (28000): Access denied for user 'zabbix_us'@'localhost' (using password: YES)
Updated: 05 March 2021, 14:29:47
mysql>show grants for 'zabbix_us'@'localhost';
ERROR 1141 (42000): There is no such grant defined for user 'zabbix_us' on host 'localhost'
Updated: 05 March 2021, 14:58:19
Судя по всему пользователь не создался.
mysql> SELECT user FROM mysql.user;
+------------------+
| user |
+------------------+
| debian-sys-maint |
| mysql.infoschema |
| mysql.session |
| mysql.sys |
| root |
+------------------+
5 rows in set (0.00 sec)
Updated: 05 March 2021, 16:15:33
понял пошел исправляться.