22.214.171.124. Restricting Access to MySQL
The ability to configure access restrictions is not available on tariffs businesshosting due to the peculiarities of the implementation of this service.
MySQL security is managed in the section "Databases"... Security settings allow you to restrict access to databases hosting account using phpMyAdmin and through external connections. Access from the sites of the same hosting account is not limited. Changes take effect instantly.
List of allowed addresses
- Only single IP addresses can be specified. Subnets cannot be specified.
- Can't add LAN IP addresses. Please note if the IP address you are adding starts as:
*— any numbers, then these are the addresses of the local network. To find the external IP address, use the tool IP definitions.
- At the bottom of the page, click "Add IP to allowed list".
Enable / Disable Access Restriction
When access restriction is enabled, Stored Procedures, Functions, Triggers and Views may stop working. Therefore, we do not recommend enabling access restriction when there are stored procedures or functions.
- At the bottom of the page, click "IP restriction disabled / enabled".