MariaDB 10.6.4に作成済みのユーザーのパスワードの有効期限を設定する
環境
MariaDB 10.6.4
操作例
1.パスワードの有効期限を設定せずにユーザーを作成します。
MariaDB [(none)]> create user woka@localhost identified by '123@#';
Query OK, 0 rows affected (0.255 sec)
MariaDB [(none)]> create user woka@localhost identified by '123@#';
Query OK, 0 rows affected (0.255 sec)
MariaDB [(none)]> create user woka@localhost identified by '123@#'; Query OK, 0 rows affected (0.255 sec)
2.ユーザーのパスワードの有効期限を 20 日に変更します
MariaDB [(none)]> alter user woka@localhost password expire interval 20 day;
Query OK, 0 rows affected (0.127 sec)
MariaDB [(none)]> alter user woka@localhost password expire interval 20 day;
Query OK, 0 rows affected (0.127 sec)
MariaDB [(none)]> alter user woka@localhost password expire interval 20 day; Query OK, 0 rows affected (0.127 sec)