2.7.1.5. Restricting Access to MySQL

Note

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.

Important points:

  • 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: 192.168.*.*, 10.*.*.*, 172.16.*.*, 127.*.*.*, where * — any numbers, then these are the addresses of the local network. To find the external IP address, use the tool IP definitions.
  1. Open the section "Databases".
  2. At the bottom of the page, click "Add IP to allowed list".
  3. Enter the required IP addresses (each on a new line) and click "Save":
  1. Open the section "Databases".
  2. At the bottom of the page, in the list of allowed addresses, click ❌ in the line with the IP to be removed:

Attention!

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.

  1. Open the section "Databases".
  2. At the bottom of the page, click "IP restriction disabled / enabled".
Content