mysql赋权报错ERROR 1227 (42000): Acc

mysql赋权报错
ERROR 1227 (42000): Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

mysql> GRANT ALL PRIVILEGES ON  *.* TO 'test'@'%';
ERROR 1227 (42000): Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
mysql> GRANT ALL PRIVILEGES ON  *.* TO 'test'@'%';
Query OK, 0 rows affected (0.06 sec)

按照如下操作后解决
MySQL8.0.16版本中新增了一个system_user帐户类型，当我通过phpAdmin新增用户并赋予权限时

  CREATE USER 'homestead'@'%' IDENTIFIED WITH caching_sha2_password BY '***';
 GRANT ALL PRIVILEGES ON *.* TO 'homestead'@'%' WITH GRANT OPTION;

这个时候系统会报错：

1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
查阅了一下官方文档，原因是由于root用户没有SYSTEM_USER权限，把权限加入后即可解决：

grant system_user on *.* to 'root';