原文地址:https://blog.csdn.net/u010026255/article/details/80062153
步骤一
ALTER USER 'zabbix'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #修改加密规则
步骤二
ALTER USER 'zabbix'@'%' IDENTIFIED WITH mysql_native_password BY '123456';步骤三
FLUSH PRIVILEGES; #刷新权限
步骤四
alter user 'zabbix'@'%' identified by '123456';