Tencent Cloud

Prev Next

请输入关键字

Recent Pages

文档

Download PDF

DescribeAccounts

最后更新时间：2024-01-30 10:26:37

下载PDF

1. API Description

Domain name for API request: cdb.tencentcloudapi.com.

This API is used to query information of all TencentDB accounts.

A maximum of 50 requests can be initiated per second for this API.

We recommend you to use API Explorer

Try it

API Explorer provides a range of capabilities, including online call, signature authentication, SDK code generation, and API quick search. It enables you to view the request, response, and auto-generated examples.

2. Input Parameters

The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see Common Request Parameters.

Parameter Name	Required	Type	Description
Action	Yes	String	Common Params. The value used for this API: DescribeAccounts.
Version	Yes	String	Common Params. The value used for this API: 2017-03-20.
Region	No	String	Common Params. This parameter is not required for this API.
InstanceId	Yes	String	Instance ID in the format of cdb-c1nl9rpv. It is the same as the instance ID displayed in the TencentDB console.
Offset	No	Integer	Record offset. Default value: `0`.
Limit	No	Integer	Number of results to be returned for a single request. Value range: 1-100. Default value: `20`.
AccountRegexp	No	String	Regex for matching account names, which complies with the rules at MySQL's official website

3. Output Parameters

Parameter Name	Type	Description
TotalCount	Integer	Number of eligible accounts
Items	Array of AccountInfo	Details of eligible accounts
MaxUserConnections	Integer	The maximum number of instance connections
RequestId	String	The unique request ID, which is returned for each request. RequestId is required for locating a problem.

4. Example

Example1 Querying the information of all TencentDB accounts

Input Example

https://cdb.tencentcloudapi.com/?Action=DescribeAccounts
&InstanceId=cdb-f35wr6wj
&<Common request parameters>

Output Example

{
    "Response": {
        "RequestId": "6EF60BEC-0242-43AF-BB20-270359FB54A7",
        "TotalCount": 2,
        "MaxUserConnections": 10240,
        "Items": [
            {
                "Notes": "test",
                "Host": "localhost",
                "User": "test_user",
                "ModifyTime": "2020-11-10 01:00:00",
                "ModifyPasswordTime": "2020-11-10 01:00:00",
                "CreateTime": "2020-11-10 01:00:00",
                "MaxUserConnections": 20
            },
            {
                "Notes": "test2",
                "Host": "localhost",
                "User": "root",
                "ModifyTime": "2020-11-10 01:00:00",
                "ModifyPasswordTime": "2020-11-10 01:00:00",
                "CreateTime": "2020-11-10 01:00:00",
                "MaxUserConnections": 20
            }
        ]
    }
}

5. Developer Resources

SDK

TencentCloud API 3.0 integrates SDKs that support various programming languages to make it easier for you to call APIs.

Command Line Interface

Tencent Cloud CLI 3.0

6. Error Code

The following only lists the error codes related to the API business logic. For other error codes, see Common Error Codes.

Error Code	Description
FailedOperation.CreateAccountError	Creation failed. Please check whether the user already exists.
FailedOperation.DBOperationActionError	Database operation failed.
FailedOperation.GetPrivilegeError	An error occurred while obtaining permissions.
FailedOperation.InstanceQueryError	Query failed.
FailedOperation.PrivilegeDataIllegal	The executed operation to modify permissions is invalid. You can refer to product documentation for more information about permissions that can be modified for this instance. If you have any questions, please contact customer service.
FailedOperation.ResponseValueError	Exception with the backend request for the service. Please contact customer service.
FailedOperation.StartFlowError	Failed to initiate the operation. Please try again later. If the operation remains unsuccessful, please contact customer service.
FailedOperation.SubmitAsyncTaskError	Failed to submit the task. Please try again later. If the submission remains unsuccessful, please contact customer service.
InternalError.CdbError	System error.
InternalError.HttpError	Exceptional HTTP request
InternalError.InternalAssertError	Internal service error. Please contact customer service.
InternalError.InternalHttpServerError	An exception occurred while executing the request.
InternalError.InternalRequestError	The backend failed to request the service. Please contact customer service.
InternalError.RegexpCompileError	Regular expression compilation error.
InternalError.UndefinedError	Unknown error
InternalError.UnknownError	Unknown error
InvalidParameter	Parameter error.
InvalidParameter.ControllerNotFoundError	This API was not found.
InvalidParameter.InstanceNotFound	The instance does not exist.
InvalidParameterValue.AccountDescriptionCharacterError	The account description contains special characters.
InvalidParameterValue.AccountDescriptionLengthError	The account description should not exceed 255 characters.
InvalidParameterValue.AccountHostRuleError	Incorrect format of the `host` parameter in the account.
InvalidParameterValue.AccountPasswordCharacterError	The account password contains invalid characters.
InvalidParameterValue.AccountPasswordLengthError	The account password is too long or too short.
InvalidParameterValue.AccountPasswordRuleError	The password format is incorrect. It should contain 8 to 64 characters and must contain at least two character sets of the following: letters, digits, and special symbols (_+-&=!@#$%^*()).
InvalidParameterValue.InvalidParameterValueError	Invalid parameter value
InvalidParameterValue.UserNameRuleError	Incorrect format of the account username.
InvalidParameterValue.UserNotExistError	The account does not exist.
InvalidParameterValue.VerifyAccountNoRootError	No root account found.
InvalidParameterValue.VerifyAccountPasswordError	Invalid account password.
InvalidParameterValue.VerifyAccountPrivError	The account does not have the GRANT permission.
MissingParameter.AccountMissingParameterError	Account-related parameters are missing.
OperationDenied.DeleteRootAccountError	The root account cannot be deleted.
OperationDenied.InstTypeNotSupport	The current instance type does not support this operation.
OperationDenied.NotSupportModifyLocalRootHostError	The host information of the local root account cannot be modified.
OperationDenied.OperationDeniedError	Operation denied
ResourceNotFound.CdbInstanceNotFoundError	The instance cannot be found. Please check whether your instance status is normal.
ResourceNotFound.InstanceNotFundError	The instance does not exist.
UnsupportedOperation	Unsupported operation.
UnsupportedOperation.PrivilegesUnsupportedError	Unsupported permission.

联系我们

联系我们，为您的业务提供专属服务。

技术支持

如果你想寻求进一步的帮助，通过工单与我们进行联络。我们提供7x24的工单服务。

7x24 电话支持

tencent cloud

Recent Pages

DescribeAccounts

1. API Description

2. Input Parameters

3. Output Parameters

4. Example

Example1 Querying the information of all TencentDB accounts

Input Example

Output Example

5. Developer Resources

SDK

Command Line Interface

6. Error Code

本页内容是否解决了您的问题？

本页内容是否解决了您的问题？

tencent cloud

注册

登录

Recent Pages

DescribeAccounts

1. API Description

2. Input Parameters

3. Output Parameters

4. Example

Example1 Querying the information of all TencentDB accounts

Input Example

Output Example

5. Developer Resources

SDK

Command Line Interface

6. Error Code

本页内容是否解决了您的问题？

本页内容是否解决了您的问题？