search

shenkonghui / issue

问题记录
0 stars 0 forks source link

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation #156

Closed shenkonghui closed 2 years ago

shenkonghui commented 2 years ago

root用户执行命令set global xxx=xxx提示

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
shenkonghui commented 2 years ago

需要采用localhost连接才有Super_priv

mysql> select Host,Super_priv,User from mysql.user where user='root'\G
*************************** 1. row ***************************
      Host: localhost
Super_priv: Y
      User: root
*************************** 2. row ***************************
      Host: %
Super_priv: N
      User: root
mysql -h localhost -u root -S /data/mysql/db_mysql/conf/mysql.sock -p密码