Hi Everyone
I hope you all are doing fine. I have a running environment of **MySQL 5.7 one Master and slave on RHEL 7.3.** Everything is working fine and now i want to check that data is replicate at slave side with the help of **"mysqlrplsync".**
I have also follow these documents for the usage of this utility.
01 : https://dev.mysql.com/downloads/utilities/
02 : https://docs.oracle.com/cd/E17952_01/mysql-utilities-1.6-en/index.html
03 : 5.23 mysqlrplsync — Replication synchronization checker
But problem is when i run this command at master side [root@master ~]# mysqlrplsync --master=root:123456A@a@localhost:3306 --slaves=repuser:123456A@a@192.168.10.22:3306.
Output like this is appears :
WARNING: Using a password on the command line interface can be insecure.
ERROR: User 'repuser' on '192.168.10.22@3306' does not have sufficient privileges to perform the synchronization check (required: SUPER and SELECT).
Important : but i also give SUPER and SELECT PRIVILEGES to repuser
here you can see
and here are the logs of Master Side
and here are the logs of Slave side
I am stuck here from last month. I don't know what i am missing now. I have also do a lot of research and read every document.
kindly solve this issue if anyone knows what i am missing now.
Best Regards
Mubashar Iftikhar