How to allow remote database connection in Plesk?

0
729
Remote Desktop connection in Plesk

Plesk:

Plesk is a commercial web hosting platform which allows a server administrator to manage the website files, databases, email accounts and DNS settings through a web-based interface. In Plesk, both MySQL and MsSQL databases can be managed and also allows to connect with remote database connectivity. If need to access a remote connection, we have to allow the IP address or subnet in the Firewall rules which will be disabled due to security reasons.

Remote Database Connection:

The Remote Database Access provides standard protocols for establishing a remote database connection between a database client and a database server. So, the databases can be easily accessed and managed from different locations. The list of IP addresses and the host that were allowed to access the databases remotely were managed in Plesk. The remote database access can improve the server performance, expand the server capacity and provides enhanced security. The users can be granted permission to access the database remotely.

Steps to allow remote database connection in Plesk:

Step 1: Login to the panel with the given username and password.

Step 2: Click on the option ‘Databases’ to create a new database.

web hosting

Step 3:  Then Go to the option ‘Add Database’ to create a new database. 
Click the option 'Add Database'

Step 4: Fill the required fields such as Database name, Database server, username, password and enable the option ‘Allow remote connections from’. Then enter the IP address of the host in which the database should be connected remotely.

Create database and allow remote access

Step 5: Then click the option ‘OK’ in which the new database will be created and the remote connection will be enabled.

Click the option 'OK'

Step 6: If the database is already created, then the remote connection will be enabled with the option ‘User Management’ for the database user.

Click the option 'User Management'

Step 7: Enter the password and choose the database and user role from the drop-down and select the option ‘Read and Write’.

Assign user role to database

Step 8: To allow the remote access, enable the option ‘Allow remote connections from’ and enter the IP address in which remote should be allowed.

Allow remote connection

Step 9: Now, click ‘OK’ and ‘Apply’ to enable the remote access and it is successfully done.

Successfully configured remote database

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here