How to create and configure Databases in Plesk?

1. To create databases you can go to the Databases area from the left menu, the Databases option, 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) or MS SQL database 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 details that will connect to the database and whether you want to give them access to all created databases.

Clicking the ACCEPT button 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 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 specific 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 change their password and privileges by clicking on their name.
5. Number of tables in the database 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 show you the details to connect to the database from an external program.
10. Tool to import a previously exported database.
11. It will allow you to copy or clone the database.
12. This tool will check the database and repair any errors it finds.

In item 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 it — you will have created a database, associated it with a user, and linked it to a hosting plan.