We use cookies
We use cookies to optimize our website. By continuing to browse the site, you agree to our use of cookies.
Control panel
  • Русский
  • Українська
  • English
  • UAH
  • USD
  • RUB
  • EUR
  • 0-800-307-307 Hotline
  • +38 (044) 392-74-33 Kiev
  • +38 (057) 728-39-00 Kharkiv
  • +38 (056) 794-38-31 Dnipro
  • +38 (032) 229-58-93 Lviv
  • +38 (048) 738-57-70 Odessa
  • +38(093) 170-15-42  Life
  • +38 (067) 400-88-44 Kievstar
  • +1(888)393-24-51  USA, Toll free
  • +44(131)507-01-14  Great Britain
  • +7 (499) 348-28-61 Moscow

2.7.1.5. MySQL security

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 “Database". 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 like: 192.168.*.*, 10.*.*.*, 172.16.*.*, 127.*.*.*where * - any numbers, then these are local network addresses. To find the external IP address, use the tool IP definitions.

To add an IP address to the allowed list, do the following:

  1. Click "Add IP to the list of allowed»:
  2. Specify the required IP addresses (each on a new line) and click "Save»:

To remove an IP address from the list of allowed ones, click the delete button opposite it:

Attention!

Stored Procedures, Functions, Triggers and Views may stop working when access restriction is enabled. Therefore, we do not recommend enabling access restriction when there are stored procedures or functions.

To enable access restriction, do the following:

  1. Click "Add IP to the list of allowed»:
  2. Check the box next to "Enable IP restriction" and press "Save»:

To disable the restriction, uncheck the checked box and save the changes.