- 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.
