Managing databases doesn’t have to be complicated, especially if you’re using Plesk Panel. Known for its user friendly interface, Plesk allows webmasters, developers, and hosting clients to create and manage databases easily without needing advanced server knowledge.
Here’s a step by step guide on how to create a database in Plesk Panel, with explanations that will help you understand what you’re doing at every stage.
Log In to Plesk Panel
The first step is to access your Plesk account.
Go to your hosting provider’s Plesk login page (often
https://yourdomain.com:8443).Enter your username and password provided by your host.
Once logged in, you’ll see the Plesk Dashboard, where you can manage your domains, emails, and databases.
Navigate to the Databases Section
From the left hand menu or the main dashboard:
Click on Databases.
You’ll see a list of existing databases (if any).
This is the section where you can create, edit, or delete databases for your websites and applications.
Click on “Add Database”
To create a new database:
Click the Add Database button.
A new form will open asking for details about your database.
Fill in Database Details
Here’s what you need to enter:
Database Name: Choose a unique name for your database (e.g.,
wordpress_db).Related Site: Select which domain the database will be linked to (if you have more than one domain in your Plesk account).
Database Server Type: Plesk typically supports MySQL or MariaDB by default, but may also allow PostgreSQL depending on your hosting plan.
Create a Database User
Every database needs at least one user to manage it. In the same form:
Enter a username (e.g.,
db_user).Set a strong password for security.
Choose whether this user has read/write access or limited permissions.
This account will be used by your website or application to connect to the database.
Set Access Permissions
Plesk also lets you specify remote access settings:
Local Access Only: Recommended for most websites (only the server can connect).
Allow Remote Connections: Enable this only if you need to connect to the database from another server or application.
Save and Create the Database
Click OK or Apply to finish.
Your new database will now appear in the Databases section of Plesk. From here, you can manage it further.
Manage Your Database with phpMyAdmin
Plesk integrates phpMyAdmin for MySQL and MariaDB (and phpPgAdmin for PostgreSQL).
Click on your database name.
Select phpMyAdmin to open a browser-based interface where you can:
Import or export tables
Run SQL queries
View and edit database content
Use the Database in Your Website or Application
Now that your database is created, you can:
Add the database name, user, and password to your website’s configuration file (e.g.,
wp-config.phpfor WordPress).Start building or migrating your site using the new database.