Modifying Host Addresses with Access Permissions
Last updated:2026-01-09 22:03:48
Operation Scenario
By modifying the host address authorized by the database account in the TencentDB for MySQL console, you can control the access to the database to improve the access security.
Prerequisites
Description of Host Address Priority
Authorized host addresses (that is, IP range) for database accounts have priority levels: the more specific the host address, the higher the priority. For example, under the same instance, if Account A allows access from 192.167.1.1, and another Account A (with the same name) allows access from 192.167.1.%, then the host address 192.167.1.% will not be able to log in. Note: In practice, do not configure multiple accounts with the same name and different host addresses.
Operation Steps
1. Log in to the MySQL console. In the instance list, click Instance ID or Manage in the Operation column to go to the instance management page.
2. On the instance management page, choose Database Management > Account Management, locate the account for which you need to modify the host, and choose More > Modify Host.
Note:
The root account does not support modifying host addresses.
3. In the pop-up Modify Host dialog box, enter the new host address and click OK.
Note:
The host address supports specifying a single IP address, or you can use % to indicate no restriction on the IP range.
Example 1: Entering % indicates no restriction on the IP range, allowing clients from any IP address to access the database with this account.
Example 2: Entering 10.5.10.% allows clients within the IP range 10.5.10.% to access the database with this account.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback