How to Manage Databases - Plesk
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:
- Log into your Plesk control panel.
- Click Databases in the left-hand sidebar.
- Click the phpMyAdmin link next to the database you wish to manage.
- When you click on the phpMyAdmin link it will open phpMyAdmin in a new window.
- phpMyAdmin is not available for MSSQL databases, which will need to be Remote Database Management Software.
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:
- Server Type - Select Database Engine.
- Server Name - You can use any address which resolves to your server, including:
- Your account's IP address
- Server hostname
- Your domain name (must be pointed to our server)
- Login - This will be your database username, which can be found in the Databases section of your control panel by selecting the database you wish to use.
- Password: This will be your database user password.
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.
- Change Database User Password:
The password you're using to log in may be incorrect. Change the database user password and try with the new password.
Note: This may break scripts using the previous password, and affected applications will need their configuration updated.
- Check Local Firewall/Security Settings:
Your router, firewall, and/or antivirus can all block access to this port. Please check all these services for your local network to ensure that port 1433 is not blocked.
Note: If these are the cause, please contact the manufacturer of these devices for modification procedures.