The user specified as a definer (‘platformadmin‘@‘%‘) does not exist.

使用工具修改mysql表数据报错:

The user specified as a definer ('platformadmin'@'%') does not exist.
1

解决方法:
依次执行语句赋予并刷新权限:

GRANT ALL PRIVILEGES ON *.* TO platformadmin@"%" IDENTIFIED BY ".";

FLUSH PRIVILEGES;
1
2
3