いつも忘れるSHOW SLAVE STATUSとかの権限

何度も忘れるのでいい加減メモ。

SHOW {MASTER|SLAVE} STATUSがSUPERまたはREPLICATION CLIENT、
SHOW SLAVE HOSTS, SHOW {BINLOG|RELAYLOG} EVENTSがREPLICATION SLAVE。

mysql55> SHOW MASTER STATUS;
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation

mysql55> SHOW SLAVE STATUS;
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation

mysql55> SHOW SLAVE HOSTS;
ERROR 1227 (42000): Access denied; you need (at least one of) the REPLICATION SLAVE privilege(s) for this operation

mysql55> SHOW BINLOG EVENTS IN 'bin.000001';
ERROR 1227 (42000): Access denied; you need (at least one of) the REPLICATION SLAVE privilege(s) for this operation

mysql55> SHOW RELAYLOG EVENTS IN 'relay.000001';
ERROR 1227 (42000): Access denied; you need (at least one of) the REPLICATION SLAVE privilege(s) for this operation

mysql55> RESET SLAVE;
ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

mysql55> RESET MASTER;
ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

本気でただのメモ。