Help & DocumentationTencentDB for SQL ServerGetting Started Creating an Instance and Connecting to a Database

Creating an Instance and Connecting to a Database

Last updated: 2019-11-06 20:21:13

PDF

You can manage the database in the TencentDB for SQL Server Console.

Creating an Instance

Log in to the TencentDB for SQL Server Console, click Create in the instance list, select the region, network, and specification of the instance, and click Buy Now to create the instance.

Creating a Database

Click an instance name to enter the instance details page. Select Database Management > Create a Database, enter the database name, select the character set. If you need to authorize an account for the database now, select "Authorize Accounts", select the corresponding database, and then set the permissions. Currently, the permissions are divided into read-write and read-only. After confirming that everything is correct, click "OK".

Set Database Permissions

After successfully creating a database, you can authorize an account for it or modify the authorization. To do so, click "Set Permissions" in the Operation column of the database:

Click > or < to add or remove permissions for the account.

Renaming a Database

You can move the cursor near the database name and the edit icon will appear. Click the icon to rename the database.

Modifying Database Description

You can move the cursor near the database description and the edit icon will appear. Click the icon to update the description:

Deleting a Database

You can delete a database by clicking Delete in the Operation column.