Zabbix所使用的数据库用户zabbix@localhost及其权限:
MariaDB [(none)]> show grants for zabbix@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for zabbix@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY PASSWORD '*DEEF4D7D88CD046ECA02A80393B7780A63E7E789' |
| GRANT ALL PRIVILEGES ON `zabbix`.* TO 'zabbix'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)
注释:数据库用户zabbix@localhost已经有备份库zabbix的权限了。
显示所有的库:
show databases;
注释:数据库用户zabbix@localhost的信息要与Zabbix的数据库配置文件的信息一致。
[root@centos8 ~]# mysql -u"zabbix" -p"zabbix" -e "show grants for zabbix@localhost;"
+---------------------------------------------------------------------------------------------------------------+
| Grants for zabbix@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY PASSWORD '*DEEF4D7D88CD046ECA02A80393B7780A63E7E789' |
| GRANT ALL PRIVILEGES ON `zabbix`.* TO 'zabbix'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
笺注:实验中,Zabbix的备份和还原都是正常的。
相关文章:
CentOS8使用计划任务CentOS6使用Python3脚本备份站点(Zabbix)+crontab计划任务