Create and Manage Databases on a Plesk Server

2 Replies • Leave your reply

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.

Manage databases with Plesk

Click the domain name.

Manage databases with Plesk

Click + Add Database.

Manage databases with Plesk

Fill out the General details for the database.

Manage databases with Plesk
  • Choose a database name.
  • Choose the website from the Related site drop-down menu.

Fill out the User information for the database.

Manage databases with Plesk
  • 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.

Manage databases with Plesk
  • 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.

Manage databases with Plesk

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.

Manage databases with Plesk

You can also find the connection information by clicking Connection info.

Manage databases with Plesk

Click phpMyAdmin to go to the PHPMyAdmin interface for the database. You will be automatically logged in.

Manage databases with Plesk

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.

Manage databases with Plesk

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.

Manage databases with Plesk