Nazmart is a multi-tenant eCommerce platform that creates and manages separate MySQL databases for each tenant store. To do this automatically, it needs access to the MySQL root account. If your server uses aaPanel, this guide will show you how to find or set your MySQL root username and password.
Why Nazmart Needs MySQL Root Access
Nazmart uses the MySQL root account to:
- Create new databases for each tenant
- Assign user privileges
- Delete or reset tenant databases
- Automate database-level operations
These actions require full database access, which can only be provided through the MySQL root account or a user with all privileges.
Step 1: Log in to Your aaPanel Dashboard
Go to your aaPanel login URL and sign in using the admin credentials. After login, you will be directed to the main dashboard.
Step 2: Open the Database Management Section
- From the left sidebar, click on Database
- You will see a list of your current databases and database users
At this point, you can manage databases, but the root password is not shown directly. Continue to the next step.
Step 3: Access the MySQL Root User
In aaPanel, MySQL is managed through the software store and service panel.
- Go to the App Store in the left sidebar
- Find MySQL under installed applications
- Click Settings or Manage
Here, you can see service configurations and access logs. However, root password details are usually not shown here directly.
Step 4: Reset MySQL Root Password in aaPanel
If you don’t know the current MySQL root password, you can reset it:
- Go to Database in the left sidebar
- Click the Root Password button at the top (it may also appear in the MySQL settings section)
- Set a new secure password
- Save the password in a secure place
Now, your MySQL root username will be root, and the password will be the one you just set.
Step 5: Update Nazmart Configuration
Once you have the root credentials, update your Nazmart environment settings.
Open your core > .env file and set the following:
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=nazmart
DB_USERNAME=root
DB_PASSWORD=your_mysql_root_password
Replace your_mysql_root_password with the new password you just created.
This will allow Nazmart to automatically create and manage tenant databases without manual input.
Security Tips
- Always store the root password in a secure password manager
- Only give root access to systems that require it, such as Nazmart
- Never share your MySQL root credentials publicly
- Perform regular backups before making changes to databases
Need Help?
If you are not sure how to access or reset your MySQL root credentials in aaPanel, contact your hosting provider or reach out to the Nazmart support team. We are here to help you configure your system correctly and securely.