Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17753

ALTER USER fail to replicate

    XMLWordPrintable

    Details

      Description

      I found that ALTER USER failed to replicate on slave(s).
      To reproduce this problem, I tried to change password on master server.

      master [localhost] {msandbox} ((none)) > ALTER USER 'msandbox'@'localhost' IDENTIFIED BY 'msandbox1';
      Query OK, 0 rows affected (0.00 sec)
       
      master [localhost] {msandbox} ((none)) > show grants for 'msandbox'@'localhost';
      +--------------------------------------------------------------------------------------------------------------------------+
      | Grants for msandbox@localhost                                                                                            |
      +--------------------------------------------------------------------------------------------------------------------------+
      | GRANT ALL PRIVILEGES ON *.* TO 'msandbox'@'localhost' IDENTIFIED BY PASSWORD '*E4042948BD58ED92656A17F1F5ADE60136095E6B' |
      +--------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

      Now, on slave password didn't changed. Check password hash between master and slave.

      slave1 [localhost] {msandbox} ((none)) > show grants for 'msandbox'@'localhost';
      +--------------------------------------------------------------------------------------------------------------------------+
      | Grants for msandbox@localhost                                                                                            |
      +--------------------------------------------------------------------------------------------------------------------------+
      | GRANT ALL PRIVILEGES ON *.* TO 'msandbox'@'localhost' IDENTIFIED BY PASSWORD '*6C387FC3893DBA1E3BA155E74754DA6682D04747' |
      +--------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

      I also verified from master binary log that ALTER USER .. is not written into binary log.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              muhammad.irfan Muhammad Irfan
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: