给mariadb 数据库授予远程访问权限

给用户最大权限

## grant all privileges on *.* to 'root'@'%' identified by '1';

# 给部分权限(zabbix 数据库)

## grant all privileges on zabbix.* to 'root'@'%' identified by '1' with grant option;

# 刷新权限表

## flush privileges;