What Accounts Are Provided by Default for a TDSQL Boundless Instance? Can They Be Deleted?
The system provides four accounts by default. It is recommended not to delete them, as doing so may cause database issues.
|
root | % | Administrator account with all privileges. |
mysql.sys | localhost | Manage and access the built-in sys database. |
mysql.session | localhost | Access the server for internal plugins. |
mysql.infoschema | localhost | Manage and access the information_schema database. |
What Permissions Does the Preconfigured High-Privilege Account dbaadmin Have?
dbaadmin is a high-privilege account created by default. It has all database management permissions except SUPER and can be used for daily management of database instances.
Why Does a Newly Created Account Have No Permissions?
A newly created account has no permissions by default. To use it, you must first click Modify Permissions in the account list and grant the required database permissions. How to Modify Account Permissions
Why Can't I Log In to the Database Management Tool DMC?
This issue may be caused by the business account you are using. To resolve it, log in to the TDSQL Boundless console, click the Instance ID, and navigate to the Instance Management > Account Management page. Confirm that the login account has been authorized for the client host address that needs to access the database. Then, set the host address to % or the specific client host address you want to authorize. You can also directly log in to the database management tool using a pre-configured high-privilege account.
If you confirm that the issue is not one of the above, your account password may be incorrect. Please re-enter your password or reset the password. What to Do If an Account Is Accidentally Deleted or the Password Is Forgotten
If you have accidentally deleted an account, you can log in to the TDSQL Boundless console, click the instance ID, and go to the Instance Management page. You can then create a new account by clicking Account Management > Create Account or by using an SQL statement. For details, see Creating Account. If you forget the administrator password, you can locate the corresponding account on the Account Management page to reset the password. For details, see Resetting Password. You can also perform these operations via the TencentCloud API. Does a TDSQL Boundless Authorized User Have No file Permission?
Currently, the shutdown and file permissions are not granted to pre-configured high-privilege users. Therefore, administrators cannot create users with all permissions. When permissions are granted, see the following commands:
grant SELECT,INSERT, UPDATE, DELETE, CREATE, DROP, ALTER on *.* to 'myuser'@'%' identified by 'mypasswd';
Does TDSQL Boundless Support Read-Only Accounts and Read-Only Nodes?
TDSQL Boundless does not currently support read-only accounts or read-only nodes. In its peer-to-peer node architecture, read and write requests can be distributed across different nodes, allowing for full utilization of each node's resources. For details on the TDSQL Boundless architecture, see Product Overview. We will add support for read-only nodes in later versions. Stay tuned.