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@

      Output like this is appears :

      WARNING: Using a password on the command line interface can be insecure.

      ERROR: User 'repuser' on '' 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




      ERROR 2.JPG

      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