Knowledge Base

How to Manage Databases (MySQL) in Plesk

  • How to Manage Databases (MySQL) in Plesk
     Accessing the Databases Section

Log in to your Plesk Panel using your username and password.
From the left sidebar, navigate to Websites & Domains, then select the domain where you want to manage your database.
Under your domain options, click on Databases to open the database management section.

  • Add Database button.
    You can click this button to start creating your first database.

  • In the Add Database window, fill in the required details:
    ◦ Database name: Enter a unique name for your database.
    ◦ Database server: Usually it will be localhost:3306 (default for MariaDB/MySQL).
    ◦ Related site: Choose the domain/site that this database will be linked to (optional).
    ◦ Database user: Create a new user by setting a username and a secure password (or use the Generate button).

Finally, click Create Database to save.

  • Managing Existing Databases

After creating databases, they will appear in the Databases list for your domain.
From this section, you can manage each database with the following options:
◦ phpMyAdmin – Open and manage your database tables, run SQL queries, import/export data.
◦ Connection Info – View details like database host, port, and username (useful for connecting external apps).
◦ Export Dump – Download a full backup of your database.
◦ Import Dump – Upload and restore data into the database.
◦ Copy Database – Duplicate an existing database into a new one.
◦ Check and Repair – Run diagnostic and repair tools if you suspect corruption.
◦ Delete  – Remove a database completely when it’s no longer needed.

 

  • Accessing phpMyAdmin
    ◦  
    Click on your database name, then choose phpMyAdmin.
    ◦  This opens phpMyAdmin in a new tab.

  • Once inside phpMyAdmin, you’ll see a set of tools at the top menu that let you fully control your database:
    ◦ Structure – View the structure of your database and tables.
    ◦ SQL – Run custom SQL queries directly.
    ◦ Search – Find specific data across tables.
    ◦ Export – Create a backup of your database.
    ◦ Import – Upload and restore database content.
    ◦ Operations – Perform advanced actions like renaming, copying, or removing databases/tables.
    ◦ Designer – Visualize your database schema.

 

Please rate this article to help us improve our Knowledge Base.

0 0