How to Create a Database in Plesk

If you need to store application data, user accounts, orders, content, or logs, the first step is usually to create a database in Plesk. In a typical hosting environment, this is one of the most common tasks performed from the control panel because it lets you manage your site’s database without using command-line tools or direct server access.

Plesk supports the most common database engines used in web hosting, including MySQL and MariaDB, and in some environments PostgreSQL as well. The exact options available depend on your hosting plan and what your provider has enabled in the Plesk instance. In most cases, you can create the database, assign a database user, and connect your website or application within a few minutes.

What you need before creating a database in Plesk

Before you start, make sure you have access to the correct subscription, domain, or service plan in Plesk. Database creation is usually available only if your hosting package includes database support and if your account has permission to manage databases.

  • A valid Plesk login with access to the domain or subscription.
  • Database management permissions enabled by the hosting provider.
  • The name of the application or site that will use the database.
  • Basic knowledge of the database type required by your CMS or app.

If you are unsure which database engine your website needs, check the documentation for your application. For example, WordPress typically uses MySQL or MariaDB, while some other platforms may support PostgreSQL.

How to create a database in Plesk

The exact interface may vary slightly depending on your Plesk version and hosting configuration, but the general process is the same.

Step 1: Sign in to Plesk

Log in to your Plesk control panel using the credentials provided by your hosting company. After you sign in, select the subscription or domain where you want to create the database.

Step 2: Open the Databases section

In the left-hand menu or the domain management area, find Databases. This section is used to create, edit, remove, and manage databases and database users.

If you do not see the Databases option, it may mean one of the following:

  • The hosting plan does not include database access.
  • Your user role does not have permission to manage databases.
  • The provider has hidden this feature in the Plesk interface.

Step 3: Click Add Database

Choose Add Database or a similar button. Plesk will open a form where you can define the database name, type, and related user credentials.

Step 4: Enter the database name

Give the database a clear and meaningful name. In a hosting environment, a simple naming pattern is often the easiest to manage. For example, if your site is called example.com, a database name such as example_db or site_db is easy to identify later.

Keep these points in mind:

  • Use only allowed characters, usually letters, numbers, and underscores.
  • Avoid spaces and special symbols.
  • Use a naming style that helps you recognize the purpose of the database.

Step 5: Select the database server and type

If multiple database servers are available, choose the one you want to use. Plesk may also ask you to select the database type, such as MySQL, MariaDB, or PostgreSQL. For most websites, MySQL or MariaDB is the standard choice.

In managed hosting environments, the server may already be preselected. If so, simply continue to the next step.

Step 6: Create or assign a database user

Most applications need a database user with a username and password. In Plesk, you can usually create a new user during database creation or assign an existing one.

Use a strong password that includes:

  • Uppercase and lowercase letters
  • Numbers
  • Special characters
  • A length of at least 12 characters when possible

If your hosting provider supports it, use the password generator in Plesk to create a strong and unique password.

Step 7: Set user privileges

Plesk usually lets you assign permissions for the database user. In many cases, the user needs full access to the database owned by that website or application. Common privileges include read, write, create, update, and delete rights.

For security, give only the permissions that are required. If the application needs full access to function, that is usually acceptable for a single-site database. However, do not reuse the same database user across unrelated projects unless there is a specific reason to do so.

Step 8: Confirm and create the database

Review the settings carefully, then click OK, Create, or the equivalent confirmation button. Plesk will create the database and user, and it will appear in the database list for that domain or subscription.

At this stage, note down the following details:

  • Database name
  • Database username
  • Password
  • Database host or server name
  • Database type

You may need these details later when connecting a CMS, ecommerce platform, or custom application.

How to connect a website or application to the new database

After you create a database in Plesk, the next step is usually to connect it to your website. The method depends on the application.

For WordPress and similar CMS platforms

During installation, you will be asked to enter the database name, database username, password, and database host. If WordPress is already installed, the database details are stored in the configuration file, typically wp-config.php.

Make sure the values match exactly. A small typo in the database name or password will prevent the website from connecting.

For custom applications

Most applications store database connection settings in a configuration file or environment file. Update the following values:

  • Database name
  • Database user
  • Database password
  • Database host
  • Port, if the application requires it

If the application is hosted on the same account as the database, the host is often localhost, but this can vary depending on the hosting setup. Always verify the correct host information in Plesk or in your provider’s documentation.

Best practices when creating databases in Plesk

Creating a database is simple, but following a few practical hosting best practices can save time later and improve security.

Use descriptive names

Choose names that make sense to you and your team. This is especially important if you manage multiple domains, staging sites, or client projects in the same Plesk account.

Keep user accounts separate

When possible, create a separate database user for each project. This makes access control easier and reduces the risk of one compromised application affecting another.

Use strong passwords

Database credentials are sensitive. A weak password can expose site data, customer records, or configuration files. In a managed hosting environment, password hygiene is one of the simplest ways to improve security.

Do not give more access than necessary

Only assign the permissions needed by the application. Overly broad privileges increase the risk of accidental changes or data loss.

Keep a record of your database details

Store the database name, username, and password securely. If you need to migrate the site, restore a backup, or troubleshoot a connection issue, this information is essential.

Back up regularly

A database often contains the most important part of a website. Make sure your backup policy includes the database, not only the website files. In Plesk, backups can often be managed separately or as part of a full subscription backup.

Common issues when creating a database in Plesk

Even though database creation is usually straightforward, a few common issues can appear in Plesk hosting environments.

The Add Database button is missing

This usually means database management is disabled for your subscription, plan, or user role. Contact your hosting provider if you believe database access should be available.

The database name is not accepted

Some names may contain invalid characters or exceed the allowed length. Try a shorter name using only letters, numbers, and underscores.

The database user cannot be created

This can happen if the username is already in use or if the plan has reached its user limit. Check whether an existing user can be reused or whether your plan needs an upgrade.

The website cannot connect after the database is created

Check the following:

  • The database name is correct.
  • The username and password match the values in Plesk.
  • The database host is correct.
  • The application supports the selected database engine.
  • The database user has sufficient privileges.

The application asks for a different database version

Some modern applications require a specific MySQL or MariaDB version. If the installed version in your hosting environment is not compatible, contact your provider to confirm whether an alternative database server is available.

How to manage databases after creation

Once the database is created, Plesk gives you several options for ongoing management. These are useful for both site owners and developers working in a hosting control panel.

Edit database settings

You can usually change the database name display label, user assignments, or access settings depending on the permissions granted by your hosting setup.

Change the database password

If you suspect a credential issue or need to update security settings, change the database user password and then update the application configuration immediately.

Open phpMyAdmin or another management tool

Plesk often provides a link to phpMyAdmin for MySQL or MariaDB databases. This allows you to browse tables, run queries, export data, and perform basic maintenance tasks through the browser.

Export and import data

Use export tools to create backups or move data between environments. This is especially useful when migrating from staging to production or restoring a site after an issue.

Remove unused databases

If a project is no longer active, delete its database and user to reduce clutter and improve security. Before removing anything, make sure you have a backup and have confirmed that the database is no longer needed.

FAQ

Can I create more than one database in Plesk?

Yes, if your hosting plan allows it. Many plans support multiple databases, but the exact number depends on your subscription limits and provider settings.

Which database type should I choose in Plesk?

Choose the type required by your website or application. For most common CMS platforms, MySQL or MariaDB is the correct option. Use PostgreSQL only if your application specifically requires it.

Do I need root access to create a database in Plesk?

No. In most hosting scenarios, you can create databases directly from the Plesk control panel without root access. If the feature is restricted, your hosting provider may need to enable it.

What should I use as the database host?

In many shared and managed hosting environments, the host is localhost, but this is not universal. Always check the connection details shown in Plesk or in your hosting documentation.

Can I use the same database for multiple websites?

Technically, it is possible in some cases, but it is usually better to keep separate databases for separate websites. This is cleaner, safer, and easier to manage during updates or troubleshooting.

How do I know if the database was created successfully?

After creation, the database should appear in the Databases section in Plesk with its assigned user and server details. You should also be able to connect the application using the saved credentials.

Conclusion

Creating a database in Plesk is a standard hosting task that gives your website the storage it needs for dynamic content, settings, user data, and application records. By using the Databases section in the control panel, you can create the database, set up a user, define permissions, and connect your site without relying on server-side commands.

For the best results, use clear naming, strong passwords, limited permissions, and regular backups. These simple practices make database management easier and more secure, especially in a managed hosting environment where multiple domains, applications, or staging sites may be handled from the same Plesk panel.

  • 0 Users Found This Useful
Was this answer helpful?