MySQL5.7版本及以上，改密码sql语句；grant创建用户已经密码

mysql> update mysql.user set authentication_string = password('*****')  where user = 'root';

 

grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';