Learn how to add and manage databases for virtual hosts on a server with Plesk.
For any server with Plesk, administrative functions like adding and managing databases should always be done using the Plesk interface.
Requirements
- A server with Plesk Onyx (any operating system)
This tutorial uses the Power User view. You can change the Plesk view by clicking Change View at the bottom of the column on the left.
Add a Database
Log in to Plesk and go to Databases.
Click the domain name.
Click + Add Database.
Fill out the General details for the database.
- Choose a database name.
- Choose the website from the Related site drop-down menu.
Fill out the User information for the database.
- Enter the username.
- Fill out the password (twice). Click Generate to generate a secure password for the user.
- Tick the box to grant this user access to all databases on the server. For security reasons, it is best to not select this option unless it is absolutely necessary.
Fill out the access controls for the database.
- Choose "Allow local connections only" to restrict database access to websites on this server. (Recommended.)
- Choose "Allow remote connections from any host" to allow any external website to connect to the database.
- Choose 'Allow remote connections from..." to set a specific URL or IP address which can make a remote connection to the database.
Click OK to create the database.
Manage Databases
Log in to Plesk and go to Databases.
This will take you to an admin panel for each database. Here you will find the options and administration tools for every aspect of the database.
The database hostname and username are displayed at the top.
You can also find the connection information by clicking Connection info.
Click phpMyAdmin to go to the PHPMyAdmin interface for the database. You will be automatically logged in.
Click Export Dump to export and download a dump file (backup copy) of the database. Click Import Dump to import data from a dump file.
Click Check and Repair to perform maintenance on a database, and repair any necessary repairs.
Click Remove Database to delete this database and all of its data.
