You can clone a database account in the TDSQL for MySQL console, and retain its original account password to provide different permissions.
- Log in to the TDSQL console. In the instance list, click an instance ID or Manage in the Operation column to enter the instance management page.
- On the database management page, select the Account Management tab, find the account for which to reset the password, and click Clone Account.
- In the pop-up window, enter the source server IP, account name, and password (the name and password can be the same as that of the original account), then click Confirm and Go Next.
- Return to the account management page to view the cloned account.