ALTER USER

语法说明

修改数据库用户的属性和密码。

Note

1. 租户可以修改它所创建的用户的密码，每次只修改 1 个用户的密码，修改后的密码将在下次登录生效，当前会话不会被中断。
2. 用户可以修改自己的密码，修改后的密码将在下次登录生效，当前会话不会被中断。

语法结构

1. ALTER USER [IF EXISTS]
2. user auth_option

4. auth_option: {
5. IDENTIFIED BY 'auth_string'}

参数释义

auth_option

修改用户的帐号名和授权方式，auth_string 表示显式返回指定密码。

示例

1. -- 创建一个名为 "admin_1" 密码为 "123456" 用户
2. mysql> create user admin_1 identified by '123456';
3. Query OK, 0 rows affected (0.02 sec)

5. -- 将用户的初始密码 "123456" 修改为 "111111"
6. mysql> alter user 'admin_1' identified by '111111';
7. Query OK, 0 rows affected (0.02 sec)

9. -- 查看是否修改密码成功
10. mysql> select * from mo_catalog.mo_user;
11. +---------+-----------+-----------+-----------------------+--------+---------------------+--------------+------------+---------+-------+--------------+
12. | user_id | user_host | user_name | authentication_string | status | created_time        | expired_time | login_type | creator | owner | default_role |
13. +---------+-----------+-----------+-----------------------+--------+---------------------+--------------+------------+---------+-------+--------------+
14. |       0 | localhost | root      | 111                   | unlock | 2023-04-19 06:37:58 | NULL         | PASSWORD   |       0 |     0 |            0 |
15. |       1 | localhost | dump      | 111                   | unlock | 2023-04-19 06:37:58 | NULL         | PASSWORD   |       0 |     0 |            0 |
16. |       2 | localhost | admin_1   | 111111                | unlock | 2023-04-21 06:21:31 | NULL         | PASSWORD   |       1 |     0 |            1 |
17. +---------+-----------+-----------+-----------------------+--------+---------------------+--------------+------------+---------+-------+--------------+
18. 3 rows in set (0.01 sec)