mysql切换system用户_Mysql5.7修改用户密码，报错“Unknown trigger has an error in its body: ‘Unknown system variable...

Mysql5.7更改用户密码，报错“Unknown trigger has an error in its body: 'Unknown system variable 'maintain_user”，这里是因为恢复数据后，直接通过“skip-grant-tables”进入Mysql修改用户密码，忽略了触发器造成的，报出上面的错误。

正常情况下，mysql5.7用户密码修改，口令为：

mysql> update mysql.user set authentication_string = password('新的密码') where user='用户名' and host='%';

mysql> flush privileges;

直接更改完退出，即可。

当出现“Unknown trigger has an error in its body: 'Unknown system variable 'maintain_user”时，是因为有触发器没有删除造成的，

查询并删除，

mysql> select trigger_schema,trigger_name from information_schema.triggers;

+----------------+----------------------------+

| trigger_schema | trigger_name |

+----------------+----------------------------+

| sys | sys_config_insert_set_user |

|