Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.9
-
All
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
- is duplicated by
-
-
- Closed
-