1227- Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for operation

转自:　　https://my.oschina.net/summergao/blog/3078348

 

修改mysql登录设置

[root@localhost ~]#  vim my.cnf

在[mysqld]段中加入

skip-grant-tables

保存之后重启mysql服务

[root@localhost ~]# service mysqld restart