The following command helps me to generate a user at the console level in MySQL
CREATE USER 'admin'@'localhost' IDENTIFIED WITH sha256_password BY pass;
With the following command I assign permissions
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';
and I end with
FLUSH PRIVILEGES;
However, the question is: How to get the system to generate the request for a new password every certain time for a user in MySQL every certain time?
Explanatory note: The encryption plugin sha256_password
that is read in the statement SQL
is available from version 5.6 of MySQL ; here the source
https://dev.mysql.com/doc/refman/5.6/en/sha256-pluggable-authentication.html