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

Set Password command doesn't update Password Column in mysql.user table

    XMLWordPrintable

    Details

      Description

      MariaDB 10.3.9 : Updating user password with SET PASSWORD command won't update the mysql.user "password" column with new password value. While Alter user command working perfectly.

       
      MariaDB server version : 10.3.9 
      MariaDB [(none)]> create user 'test123'@'localhost' identified by 'test123';
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> set password for test123@localhost=password('test123');
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
      +---------+-----------+----------+
      | user    | host      | password |
      +---------+-----------+----------+
      | test123 | localhost |          |
      +---------+-----------+----------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> set password for 'test123'@'localhost'=password('test1234');
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
      +---------+-----------+----------+
      | user    | host      | password |
      +---------+-----------+----------+
      | test123 | localhost |          |
      +---------+-----------+----------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> alter user 'test123'@'localhost' identified by 'test1234';
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
      +---------+-----------+-------------------------------------------+
      | user    | host      | password                                  |
      +---------+-----------+-------------------------------------------+
      | test123 | localhost | *3D3B92F242033365AE5BC6A8E6FC3E1679F4140A |
      +---------+-----------+-------------------------------------------+
      1 row in set (0.000 sec)
       
      While checking with previous MariaDB server version : 10.2.14 its working fine.
       
      MariaDB [(none)]> create user 'test123'@'localhost' identified by 'test123';
      Query OK, 0 rows affected (0.01 sec)
       
      MariaDB [(none)]> set password for test123@localhost=password('test123');
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
      +---------+-----------+-------------------------------------------+
      | user    | host      | password                                  |
      +---------+-----------+-------------------------------------------+
      | test123 | localhost | *676243218923905CF94CB52A3C9D3EB30CE8E20D |
      +---------+-----------+-------------------------------------------+
      1 row in set (0.00 sec)
       
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              pramod.mahto@mariadb.com Pramod Mahto
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: