How to Create and Manage Databases

Add MySQL or PostgreSQL databases and users.

Steps

  1. Go to Databases.

  2. Click Add Database.

  3. Enter the name, user, password and ssign the database to a domain.

  4. View connection details and connection options Once the database is created, you can view the connection details (hostname, username, database name, and port) by clicking on the database name in the list.

    There are two main ways to connect to your database:

    • Via phpMyAdmin (for MySQL/MariaDB) From the Plesk interface, simply click on the "phpMyAdmin" icon next to your database. It will open a web-based interface where you can manage tables, run SQL queries, import/export data, etc.

  • Using external tools like HeidiSQL, DBeaver or pgAdmin Use the connection information (host, port, database name, username, and password) to connect using a desktop application. This is especially useful for advanced management or when handling large datasets.

💡 Tip: Ensure your hosting provider or server firewall allows external database connections if you're connecting from outside the Plesk panel.

Last updated