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
本気でただのメモ。
0 件のコメント :
コメントを投稿