How to create a database in Plesk
Most CMSs need a database: WordPress, Joomla, OpenCart and others. By default, Plesk creates a MariaDB 10.5 database (MySQL-compatible). If your site needs Microsoft SQL Server, see MS SQL databases in Plesk.
Creating a database
- In the left menu, open Databases and click Add Database.
- Database name: the panel adds a prefix automatically (your username followed by an underscore). Type your own name after it, for example
shop. - Database server: keep the default server marked default for MariaDB.
- Related site: select the site the database belongs to (optional).
- Keep Create a database user selected and enter the Database user name and Password (or click Generate).
- Click Create Database.

The Database server list also includes MS SQL servers of several versions. Choose them only for sites that need MS SQL.
Connection details for your site
The new database appears in the list. The Connection info link shows the details for your site's configuration file:
| Setting | Value |
|---|---|
| Host | as shown in Connection info; for MariaDB, localhost:3306 |
| Database name | the full name including the prefix |
| User | the full database user name |
| Password | the password you set when creating the database |

phpMyAdmin opens a web interface for working with tables. Import dump and Export dump load and save a dump: importing and exporting a database.
Common mistakes
- The site configuration uses the database name without the prefix, which causes "Unknown database" or "Access denied" errors.
- The user password is forgotten. Set a new one on the User Management tab: database users.
- An MS SQL server was selected instead of MariaDB. PHP-based CMSs (WordPress, Joomla and others) work with MariaDB.