Question Use Plesk Database to external server

[shanmuga]

Server operating system version

Ubuntu 20.04 aarch64

Plesk version and microupdate number

Plesk Obsidian 18.0.47.5

Hi,

I have MySQL database in my Plesk. I want to use it in another server. I am not looking for exporting from plesk and importing where i want to use.

Let says,

158.1.1.0 - my plesk database
178.1.1.0 - different server where i want to use plesk database.

How can i make connection directly to my plesk database?

 

[Peter Debik]

Please refer to this article

Plesk with Centralized Database and Network File System

In this guide, you will learn how to deploy and configure Centralized Database and Network File System storage with Plesk.

www.plesk.com

that describes how to set up the database externally. The only difference you will need is that you won't be using n nodes, but only 1 node.

 

[Kaspar]

@shanmuga I think you're look for remote database access and is described in the support article I linked below. Note that this is only possible for database you've created your self on your Plesk server. Not for the Plesk PSA database (where Plesk stores server data and settings).

https://support.plesk.com/hc/en-us/articles/213904365-How-to-enable-remote-access-to-MySQL-server-in-Plesk-