ISPmanager 6 Lite, Pro, Host Documentation

Remote access to MySQL-server

ISPSystem

Introduction


A MySQL server can accept incoming connections from specific IP addresses. By default every MySQL-server listens to local IP address 127.0.0.1, every MariaDB server accepts all connections (i.e. it listens 0.0.0.0). In ISPmanager Lite (Pro, Host) you can set up remote access.

This function is not available for PostgreSQL

Navigate to Settings → Database servers → select a server, and click Edit. On the form that will open, enable remote access, and select an IP address.

Creating a database user


User creation and edit procedures will be changed in the course of time. If Remote access is enabled for the server where a user should be located, the corresponding checkbox will be hidden on the user configuration form.

Thank you for your feedback!
Was the article useful?
Tell us why not:

it does not match the title

it was hard to understand

I didn't find the answer

recommendations from the article did not help

other

Tell us what you didn't like in the article: