You can clone a database account in the TDSQL for MySQL console, and retain its original account password to provide different permissions.
Directions
1. 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.
2. On the database management page, select the Account Management tab, find the account for which to reset the password, and click Clone Account.
3. 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.
4. Return to the account management page to view the cloned account.
