Remote access to MySQL-server

From ISPWiki
Jump to: navigation, search

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 and Business 5.90.0 and later you can set up remote access.

 Note! This function is not available for  PostgreSQL

Lite

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.


Business

Navigate to Cluster settings --> Cluster nodes --> select a server with MySQL server role --> click Edit. On the form that will open enable remote access, and select an IP address.


Note! For new installations, remote access will be disabled on a cluster node.  By default, remote access to all cluster nodes with a MySQL database server role is enabled (IP address will be set to 0.0.0.0).

Creating a database user

User creation and edit procedure will be changed in the course of time. If remote access is now allowed for the server, where a user should be located, the corresponding check box will be hidden on the user configuration form.


Installation of APS-scripts

In ISPmanager Business the APS scripts setup procedure will be modified: if the main role is assigned to the cluster nodes which role differs from its MySQL role, you will get the following error when trying to install an APS, in case remote access is now allowed: