[MDEV-12715] remove mysql.user.password column Created: 2017-05-06  Updated: 2019-02-05  Resolved: 2018-11-11

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-17658 change the structure of mysql.user table Closed
Relates
relates to MDEV-11340 Allow multiple alternative authentica... Closed
relates to MDEV-16774 SET PASSWORD and ALTER USER with slig... Closed

 Description   

mysql.user.password column is redundant and it's removed from mysql-5.7.

we should remove it too, but old mysql.user tables (with the password column) should still be supported.

  • mysql_system_tables
  • mysql_fix_privilege_tables
  • sql_acl.cc
    • loading
    • insert/update user

 Comments   
Comment by Daniel Black [ 2019-02-05 ]

Why was this closed?

Comment by Sergei Golubchik [ 2019-02-05 ]

because the new mysql.global_priv table has no password column and the mysql.user view is frozen at the structure of 10.3, it's not supposed to be changed anymore.

Generated at Thu Feb 08 07:59:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.