How to create and configure Databases in Plesk?

1. To create databases you can enter the databases area from the left menu, option Databases, or from the same option in the central menu of the Information Panel tab.

2. If you have databases created you will see them on this screen. With the Add Database button you can create a new database.

3. The form to create the database will ask for the database name and will allow you to choose between a MariaDB (MySQL type) database or MS SQL for Windows environments.

From Related site, you can associate the created database with your account or leave it unassociated.

Then it will ask for the user data that will connect to the database and whether you want to grant it access to all existing databases.

With the ACCEPT button you will save the database.

4. After creating your database you will return to the screen from step 2, where you will now see information and the options for your new database.

There are several options and data on this screen:

1. Database name, with the Plesk user prefix.
2. Association with the specified hosting account (if you have more than one domain or website).
3. Connection details and database type.
4. Users associated with the database. You can modify their password and privileges by clicking their name.
5. Number of tables the database has and how much space it occupies.
6. Access to phpMyAdmin, a web database editor.
7. Tool to export the database.
8. Option to delete the database.
9. This option will display the details to connect to the database from an external program.
10. Tool to import a previously exported database.
11. Allows you to copy or clone the database.
12. This tool will check the database and repair any errors it finds.

In point 4 we show the user associated with the database. By clicking on their name you can edit their details and access privileges. You will see this screen:

5. That’s all — you will have created a database, associated it with a user, and linked it to a hosting plan.