更新时间:2022-09-22 08:30:30
060807 11:40:17 [ERROR] While trying to obtain the list of slaves from the master 'xxx.xxx.xxx:3306', user 'rep' got the following error: 'Access denied. You need the REPLICATION SLAVE privilege for this operation'
mysql>SHOW GRANT FOR 'rep'@'192.168.0.2'\G *************************** 1. row *************************** Grants for rep@192.168.0.2: GRANT SELECT, REPLICATION SLAVE ON *.* TO 'rep'@'192.168.0.2' IDENTIFIED BY PASSWORD 'xxx'
SHOW SLAVE HOSTS;