reuse_ check_ history
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: System Tables for MariaDB Enterprise Server
Topics on this page:
In 10.6 ES, 10.5 ES, 10.4 ES:
Hashed password history data for the password_
reuse_. check plugin
In 10.6 CS, 10.5 CS, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
See also: System Tables for MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
See also: System Tables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES
This system table is created and updated by the password_
Each row in the table stores a cryptographic hash and a date. The hashed data includes information about the affected user and the password that is being set. Because it is a one-way cryptographic hash, the stored data cannot be used to extract the prior password values nor which user the historical record is associated with.
The amount of time that the historical records are kept is controlled by the password_
0 to indicate that the records do not expire. The default is for the data to never expire.
CREATE TABLE `password_reuse_check_history` ( `hash` binary(64) NOT NULL, `time` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`hash`), KEY `tm` (`time`) )