Creating a Database Account
Function
This API is used to create a database account for a specified DB instance.
- Before calling an API, you need to understand the API in Authentication.
- Before calling this API, obtain the required region and endpoint.
Constraints
Databases cannot be created when the DB instance is in any of the following statuses: creating, changing instance class, changing port, frozen, or abnormal.
URI
- URI format
POST https://{Endpoint}/v3/{project_id}/instances/{instance_id}/db_user
- Example
https://rds.cn-north-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/db_user
- Parameter description
Table 1 Parameter description Name
Mandatory
Description
project_id
Yes
Specifies the project ID of a tenant in a region.
For details about how to obtain the project ID, see Obtaining a Project ID.
instance_id
Yes
Specifies the DB instance ID.
Request
- Parameter description
Table 2 Parameter description Name
Mandatory
Type
Description
name
Yes
String
Specifies the username of the database account.
The username consists of 1 to 32 characters. Only lowercase letters, digits, hyphens (-), and underscores (_) are allowed.- If the database version is MySQL 5.6, the username consists of 1 to 16 characters.
- If the database version is MySQL 5.7 or 8.0, the username consists of 1 to 32 characters.
password
Yes
String
Specifies the password of the database account.
Valid value:
The value cannot be empty and must be 8-32 characters. It can contain only uppercase letters, lowercase letters, digits, and the special characters (~!@#%^*-_=+?). The value cannot be the same as the name value or the name value in reverse order.
You are advised to enter a strong password to improve security, preventing security risks such as brute force cracking.
- Request example
{ "name": "rds", "password": "Test@12345678" }
Response
- Normal response
Table 3 Parameter description Name
Type
Description
resp
String
Returns successful if the invoking is successful.
- Example normal response
{ "resp": "successful" } - Abnormal response
For details, see Abnormal Request Results.
Status Code
For details, see Status Codes.
Error Code
For details, see Error Codes.
Last Article: Deleting a Database
Next Article: Querying Details About a Database User (Discarded)
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.