Editing User Information

Updated on 2023-03-07 GMT+08:00

View PDF

Scenarios

This section describes how to edit user information, including the username, password, global permissions, object permissions, advanced settings, and roles.

NOTE:

The role function is available only to MySQL 8.0.

Procedure

On the top menu bar, choose Account Management > User Management. In the user list, locate the target user and click Edit in the Operation column.
NOTE:
- Modifying permissions for multiple users cannot be modified at the same time. For example, if two users with the same username and different host addresses of 192.% and 193.% are created, modifying permissions of one user with the host address of 192. does not affect the permissions of the other user.
- When you edit a user, adding host addresses to the user does not create multiple users. For example, if a user already has a host address, 192.%, adding host address 194.% to it does not create another user with the host address of 194.%. This operation only changes the host address of the user from 192.% to 192.%,194.%.
On the displayed page, edit user information, set global and object permissions, and click Save. In the displayed dialog box, click OK.