How to Manage Databases - Plesk
Posted by Reports user on 22 September 2016 09:01 AM
When managing a database on a Plesk control panel, how you connect will depend on the type of database you are using. If you are using an MSSQL database, you'll need to use software to manage your database remotely, however, if you use MySQL you will be able to manage it either remotely, or with phpMyAdmin.
See below for information about each method for managing your database and how to use it:
phpMyAdmin allows you to manage your MySQL database in your web browser without the need to download & install a database management program. phpMyAdmin can be accessed via your Plesk control panel.
To locate the Webadmin link from your control panel, perform the following steps:
If you are using an MSSQL database, you will need to access it with remote software.
Note: In order to manage your Microsoft SQL databases, you will first need download and install Microsoft SQL Management Studio.
When opening MS SQL Management Studio, you will see a login screen which requires the following details:
Common Issues When Remotely Logging In
The Cannot Connect to Server IP error is a common error message which may occur when you attempt to log into MSSQL Server remotely. There are multiple possible solutions to this error listed below. If you are still receiving an error message after eliminating these possibilities, please contact us for assistance.