问题描述
1227 Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
问题分析
root用户没有SYSTEM_VARIABLES_ADMIN权限。
解决方案
grant SYSTEM_VARIABLES_ADMIN on *.* to 'root';
flush privileges;