Overview
Creating a database in Plesk is essential for running dynamic websites or applications that rely on data storage. This guide walks you through setting up a new database, assigning users, and managing access securely.
Why You Might Need to Create a New Database
Databases are required for:
● Content Management Systems like WordPress, Joomla, or Drupal
● E-commerce platforms like Magento or WooCommerce
● Custom web applications that store data, user accounts, or product info
Setting up a dedicated database, you ensure organized, secure, and scalable data management for your website.
Step 1– Login to Plesk.
- Go to your hosting Plesk control panel account. Enter your username and password, then click “Log in.”
Step 2– Click on Add Databases.
Once logged in:
1. Click on Websites & Domains from the left-hand menu
2. Select your domain
3. Click on Databases
Step 3– Complete Database information and click OK.
1. Click on Add Database
2. Fill in the required fields:
○ Database Name: Choose a name that relates to your website or app
○ Related Site: Select the domain this database will be associated with
○ Database User: Create a new user or assign an existing one
○ Password: Choose a strong, secure password
3. Click OK to create the database
Step 4– New created database will be listed under Databases.
After creation, you’ll be able to:
● Access the database using phpMyAdmin (for MySQL) or pgAdmin (for PostgreSQL)
● Modify user permissions
● Import or export data
● Connect your application or CMS to the database using the database name, username, and password
Troubleshooting and FAQs
I can’t find the ‘Databases’ tab: You may not have access permissions. Contact your hosting provider or account administrator to check your role.
What is the difference between MySQL and PostgreSQL? Both are relational database systems. MySQL is commonly used with PHP applications like WordPress, while PostgreSQL is often chosen for more complex applications due to its advanced features.
How do I connect my app to the new database? You’ll need the database host (usually localhost), name, username, and password. These are entered in your application’s configuration file.
Best Practices for Database Management
● Always use strong passwords for database users
● Limit user permissions based on the application’s needs
● Regularly backup your databases to avoid data loss
● Remove unused databases to reduce clutter and security risk
Additional Resources For advanced database management options, refer to the official Plesk documentation: https://docs.plesk.com/
Summary
Setting up a new database in Plesk is quick and secure. Whether you’re launching a CMS, an online store, or a custom app, this process ensures you have the correct data structure to support your project. Need help? Contact 1-grid Support for expert assistance.