Modifying Authorized Host Address

Recent Pages

Modifying Authorized Host Address

Last updated: 2023-08-24 09:42:48

You can modify the host address authorized by a database account in the console. By doing so, you can control the access to the database and enhance database connection security.
Directions
Note：
You can’t modify the host address of the root account.
1. Log in to the TDSQL-C for MySQL console.
2. Select a region at the top and proceed according to the actually used view mode.
Tab view
List view
Click Target Cluster in the cluster list on the left to enter the cluster management page.
﻿
Find the target cluster in the cluster list and click the Cluster ID or Manage in the Operation column to enter the cluster management page.
﻿
3. On the cluster management page, select the Account Management tab and select More > Modify Host in the Operation column.
﻿
4. In the pop-up window, enter a new host address and click OK.
Note：
The host address can be an IP or % (indicating no limit on the IP range).
Example 1: Enter % to indicate no limit on the IP range, that is, clients at all IP addresses are allowed to use this account to access the database.
Example 2: Enter 10.5.10.% to indicate that clients with an IP range within 10.5.10.% are allowed to use this account to access the database.
﻿