语句如下:

    1. create_user_stmt:
    2. CREATE USER [IF NOT EXISTS] user_name [IDENTIFIED BY 'password'];
    3. alter_user_stmt:
    4. ALTER USER user_name ACCOUNT {LOCK | UNLOCK};
    5. | ALTER USER user_name IDENTIFIED BY 'password';
    6. | SET PASSWORD [FOR user_name] = PASSWORD('password');
    7. | RENAME USER rename_user_action_list;
    8. drop_user_stmt:
    9. DROP USER user_name_list;
    10. rename_user_action_list:
    11. rename_user_action [, rename_user_action ...]
    12. rename_user_action:
    13. user_name TO user_name
    14. user_name_list:
    15. user_name [, user_name ...]
    16. password:
    17. STR_VALUE
    1. create_user_stmt:
    2. CREATE USER [IF NOT EXISTS] user_name [IDENTIFIED BY 'password'];
    3. alter_user_stmt:
    4. ALTER USER user_name ACCOUNT {LOCK | UNLOCK};
    5. | ALTER USER user_name IDENTIFIED BY 'password';
    6. | SET PASSWORD [FOR user_name] = PASSWORD('password');
    7. | RENAME USER rename_user_action_list;
    8. drop_user_stmt:
    9. DROP USER user_name_list;
    10. rename_user_action_list:
    11. rename_user_action [, rename_user_action ...]
    12. rename_user_action:
    13. user_name TO user_name
    14. user_name_list:
    15. user_name [, user_name ...]
    16. password:
    17. STR_VALUE