Mysql5.7修改用户密码,报错“Unknown trigger has an error in its body: ‘Unknown system variable ‘maintain_user”
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