0 Replies Latest reply on May 11, 2018 10:17 AM by Mubashar Iftikhar

    MySQL5.7 : mysqlrplsync utility

    Mubashar Iftikhar

      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

      Privileges.JPG

       

       

      ERROR 2.JPG

      and here are the logs of Master Side

       

      Master.JPG

       

      and here are the logs of Slave side

       

      Slave.JPG

       

       

      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