[MDEV-24102] GRANT USAGE ON *.* TO USER IDENTIFIED VIA unix_socket" changes password_last_changed Created: 2020-11-03  Updated: 2020-11-08

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.4.15
Fix Version/s: None

Type: Bug Priority: Trivial
Reporter: Daniel Black Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-24103 mysqldump --system=users password_la... Open

 Description    

MariaDB [(none)]> select * from mysql.global_priv;
 
...
 
| %               | USER                     | {"access": 0, "plugin": "unix_socket", "authentication_string": "", "password_last_changed": 1604371611}                                        
 
 
MariaDB [(none)]> GRANT USAGE ON *.* TO `USER`@`%` IDENTIFIED VIA unix_socket;
 
Query OK, 0 rows affected (0.001 sec)
 
 
 
MariaDB [(none)]> select * from mysql.global_priv;
 
...
 
| %               | USER                     | {"access": 0, "plugin": "unix_socket", "authentication_string": "", "password_last_changed": 1604378772}                                        ....


Generated at Thu Feb 08 09:27:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.