(Advanced) Website Databases

If your website incorporates custom data processing applications or is designed to generate web pages dynamically, you will probably need a database for storing and retrieving data.

In Plesk, you can manually create a database for your site, make a database copy and manage database user accounts. These operations are available in Websites & Domains tab > Databases. In addition, you can use the third-party database management tools supplied with Plesk to edit tables in databases, export and import data, and run SQL queries. These tools are available under the Webadmin link in Websites & Domains tab > Databases and may vary depending on the database type. For example, Plesk employs phpMyAdmin to manage MySQL databases.

Note that when you install an app from the Application Catalog, all required databases and database user accounts are created automatically. Alternatively, you can assign a manually created user account to a database created by a web app. For more information, see the section Web Applications > App Databases.

Accessing Databases with ODBC

If you wish to deploy an application which works with a database through an Open Database Connectivity (ODBC) driver, you will need to create an appropriate ODBC data source in the operating system. In Plesk for Windows you can add ODBC data sources for a number of supported ODBC drivers. For more information, see Accessing Databases with ODBC (Windows).

For the details on operations with databases and database users, refer to the relevant sections of this chapter.