Database Management Tools

Database management tools provide a web interface for the administration of databases. The tools also allow running SQL queries from this user interface.

Plesk is shipped with the following database management tools:

  • phpMyAdmin is used for MySQL/MariaDB databases.
  • pgMyAdmin is used for PostgreSQL databases.

Note

You need to install these tools first in Tools & Settings > Updates > Add/Remove Components.

For Microsoft SQL Server, you can download, install, and configure local database clients (for example, HeidiSQL or SQL Server Management Studio (SSMS)).

Enabling direct access to phpMyAdmin

You can enable direct access to phpMyAdmin and make it accessible by browsing the following URL:

https://<host-name-or-IP>:8443/phpmyadmin

To do so, add the following lines to the panel.ini file:

[databaseManagement]
features.phpMyAdmin.loginForm.enabled = on

To open a database management tool for the selected database server:

  1. Go to Tools & Settings > Database Servers.
  2. Click the image-71942.png icon corresponding to the database server you need to manage. One of the supported database management tools (depending on the database engine) will open in a separate browser window.