How to create and set up Databases in Plesk?

1. To create databases, you can access the databases section from the left menu, under the Databases option, or from the same option in the central menu tab Information Panel.

1. If you have existing databases, you will see them on this screen. By clicking on the Add Database button, you can create a new database.

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

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

Next, it will ask for the user data that will connect to the database and if you want to grant access to all created databases.

Clicking the ACCEPT button will save the database.

1. 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 data and database type.

4. Users associated with the database. You can modify their password and privileges by clicking on their name.

5. Number of tables in the database and the space occupied.

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 data to connect to the database from an external program.

10. Tool to import a previously exported database.

11. You can copy or clone the database.

12. This tool will check the database and repair any errors it finds.

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

1. That's it, you have created a database, associated it with a user, and linked it to a hosting plan.