How do databases work with websites

Plesk Documentation and Help Portal

If your website includes custom computing applications or you want web pages to be generated dynamically, you will likely need a database to store and retrieve data.

In Plesk, you can do the following:

These actions can be accessed from the Websites & Domains > Databases to be selected.

The active and the classic list

In the default setting, the list of databases is in display mode Active list displayed. You can switch to the mode using the icon next to the search field Classic list switch. The main difference between the two modes is that in the active list View statistics on the database and the name of the website to which the database is assigned.

Database management tools

Third-party database management tools are provided with Plesk. They allow you to edit tables in databases, export and import data, and run SQL queries. The tools are available from the relevant link on the tab Websites & Domains > Databases. For example, Plesk uses the phpMyAdmin tool to manage MySQL databases.

Automatic creation of databases

When installing an app from the application catalog, all required databases and database user accounts are automatically created. You can also assign a manually created user account to a database created by a web app. See the section for more information Web applications > App databases.

Accessing databases with ODBC

If you want to provide an application that works with a database via an "Open Database Connectivity" driver (ODBC driver), create a suitable ODBC data source in the operating system. In Plesk for Windows, you can add ODBC data sources for a variety of supported ODBC drivers. For more information, see the Accessing Databases Using ODBC (Windows) section.