How create a database and database user in Plesk

March 7, 2022 / Plesk Panel

In this tutorial, we’ll show you how to set up a database and a database user in Plesk.

Follow the steps:

  1. Open Plesk and log in.
    Plesk Login
  2. Select Databases from the menu.
  3. Click Add Database to create a new database.
    Database
  4. In the Database name field, type the database’s name.
  5. Select a database server from the Database server dropdown menu.
  6. From this option, choose a website to which the database should be assigned.
    website
    Note: In the Database user name area, provide the name of the database user you want to create.
  7. In the Password field, type the password. Your password must be alphanumeric, which means it must contain a mix of upper and lower-case letters, digits, and special characters.
  8. In the Confirm password field, use the same password.
  9. Simply select ‘Generate’ if you wish to use an auto-generated password. The random password is automatically filled in the Password and Confirm Password sections.
  10. Select Show to see the password.
  11. This password should be copied and pasted into a notepad file for future reference.
  12. You may choose to hide the password.
  13. Select this checkbox if you wish to grant this user access to all databases created under this subscription.
    databases created
  14. You can authorize the user to access the database using these settings in the Access control area.
    Access control
  15. This option allows you to exclusively use local connections to access the database.
    access the database
  16. This option is enabled by default, and it allows you to connect to the database remotely from any host.
    database remotely
  17. Select this option if you wish to allow remote connections from specific IP addresses or domain names.
    specified IP
  18. Here, we have selected the default option.
    default option
  19. Click OK to establish a database and database user.
  20. You will receive a message congratulating you on your accomplishment.
  21. User Management is where you’ll find your new database user.
  22. You can update the username’s settings at any moment by clicking on it.

Following the steps outlined-above helps maintain database integrity and allows smooth interaction between your application and the database.

Spread the love