Most features and changes for your shop can be done within the PrestaShop back office. However, there may be times when you need to directly interact with the database. This could be due to troubleshooting or even making mass changes to the database that are not available in the back office. In this case, however, you will need to know the database name.

While this is easy if you are only using one database on your account, some accounts have dozens of databases running. It then becomes like a needle in a haystack. Below are steps to take to find your database name.

How to find the database name for PrestaShop 1.5

  1. Log into your cPanel dashboard.
  2. Now that you are in the cPanel, enter the File Manager.
  3. Once you enter the File Manager, navigate to the root folder for your PrestaShop store. In our example, the folder is named prestashop and is under the public_html root folder.
  4. Under the root folder for your PrestaShop store, locate and enter the config folder.
  5. Now that you are in the config folder, you will need to open the settings.inc.php file. To open the file, highlight it and click on the Edit icon located in the toolbar across the top.
  6. You will see several lines of text inside the file. Look for the line of code with DB_NAME in it. Using the line of code below as an example, the second parameter is the full database name, which is compiled of the cPanel username (userna5) and the database name (_presta1).

    define('_DB_NAME_', 'userna5_presta1');
  7. Be sure to write database name down so you can remember reference it later. This allows you to quickly locate your database when using tools like phpMyAdmin no matter how many databases are in the list.

 

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.