Flash Sale:75% Off Hosting + Free DomainEnds in13h47m14sView Plans
Hostvento logoHostvento

Create a database and a database user in Plesk

This guide shows you how to make a database and a user who can open it.

Plesk1 min read13 steps7 screenshots

What is a database?

A database is a digital filing cabinet. Websites such as WordPress keep posts, pages and users in it. A database user is like a person with a key to that cabinet. Each site should have its own database and its own user.

Plesk is a control panel, a web page where you manage your hosting.

Create a database

  1. Log in to Plesk.
  2. Click Databases in the left menu. You can also open Websites & Domains and click Databases.
  3. Click Add Database.
    Screenshot: Click Add Database .
  4. Type a database name. Use letters and numbers only.
  5. Choose the related domain.
  6. In the user section, type a database username.
    Screenshot: In the user section, type a database username.
    Screenshot: In the user section, type a database username.
  7. Type a strong password. Mix letters, numbers and symbols. Save it safely, because you will need it.
  8. Click OK.

Add another user

  1. Go to Databases.
  2. Click User Management next to the database.
  3. Click Add Database User.
    Screenshot: Click Add Database User .
    Screenshot: Click Add Database User .
  4. Type a username and a strong password.
  5. Click OK.

Open the database

Click Webadmin next to the database. This opens phpMyAdmin, a tool to look at the tables inside.

Connect your site

Your site needs four facts: database name, username, password and host. The host is usually localhost, which means "this same server".

Tip: Warning: Remove Database deletes all its data for good. Take a backup first.

Need help? Open a support ticket.

Screenshot: Need help? Open a support ticket .

Quick recap

  • A database stores your site's content.
  • Use Databases then Add Database.
    Screenshot: Use Databases then Add Database .
  • Create a user with a strong password.
  • Use User Management to add more users.
  • Back up before deleting anything.