If you’re using Nazmart, a multi-tenant eCommerce platform, you may need to access your MySQL database for tasks like backups, troubleshooting, or integration. This guide explains how to find your MySQL root username and password using the Plesk hosting control panel.
Step 1: Log in to Plesk Panel
Start by logging into your Plesk panel using the link and credentials provided by your hosting provider. Once logged in, you will see the main dashboard.
Step 2: Open the Databases Section
From the left-hand menu, click on “Databases.” This page lists all the databases connected to your websites, including those created by your Nazmart system for each tenant.
You can click on “phpMyAdmin” next to a database to view or manage it directly. However, this does not show your root credentials.
Step 3: Get Root Password from Server (Requires Root Access)
If you have root access to your server through SSH, you can retrieve the MySQL root password with the following command:
cat /etc/psa/.psa.shadow
This file contains the MySQL root password used by the Plesk system. The root username is usually either admin or root.
Please be careful. Do not share this file or its contents with others.
Step 4: If You Don’t Have Root Access
If you do not have SSH or root access, the best and safest way is to contact your hosting provider. You can request:
- The MySQL root username and password
- Or ask them to reset the credentials for you
Most providers are used to handling such requests and can help you securely.
Why You Might Need Root Access
As a Nazmart user, you may need MySQL root access to:
- Manage database for your website users
- Run custom queries
- Troubleshoot tenant-level issues
However, it’s recommended to use database users with limited access whenever possible, especially for day-to-day operations.
Tips to Keep Your Data Safe
- Never share your root credentials publicly
- Store your password securely using a password manager
- Always create backups before making changes to your database
- Use limited-permission users for regular tasks to reduce risk
Need Help?
If you’re unsure how to proceed, contact your hosting provider or the Nazmart support team. They can help you with the best way to access and manage your database securely.