pymysql.err.OperationalError: (1227, 'Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation')
UNSUPPORTED COMMAND: LOAD" [180cc370ef50][-1] [122de094-5108-a00b-f948-180cc370ef50
pymysql.err.OperationalError: (1227, 'Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation')
UNSUPPORTED COMMAND: LOAD" [180cc370ef50][-1] [122de094-5108-a00b-f948-180cc370ef50
缘由:
原因是MySQL8版本中新增了一个system_user帐户类型,但是由于root用户没有SYSTEM_USER权限,所以出现问题,把权限加入后即可解决
解决办法:
对没有权限的用户授权,如对root授权
GRANT system_user ON . TO 'root';