InMotion Hosting Support Center

While most features of your PrestaShop are found in the Back Office administrative area, you may need to make adjustments outside of the interface under certain conditions. Perhaps you need to alter one or more columns in the database directly or in bulk, such as a mass price change. In cases such as this, you will need to know which database to connect your database management tool, such as phpMyAdmin, to. Below is a set of steps that will help you to determining which database your PrestaShop 1.5 store is running.

Finding the database name for your PrestaShop 1.5 store

  1. First, log into your cPanel dashboard.
  2. Once inside the cPanel, you will need to enter the File Manager.
  3. After entering the File Manager, navigate to the root folder for your PrestaShop store. In our example, the folder is named prestashop and is located 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 file. To open the file, highlight it and click on the Edit icon located in the toolbar across the top.

  6. Once opened you will see several lines of code for various settings. Look for the DB_NAME line of code. You will see the database name defined on the right side of the code line. In our example, the database name would be _pstest1. The database name will be preceded by your cPanel username (userna5). You can see a sample line of code below:
    define('_DB_NAME_', 'userna5_pstest1');
  7. Write down the database name so you can remember it. Now you can locate the particular database to use for editing no matter how many you have in your account.
Was this article helpful?
Continued Education in Course Prestashop 1.5
You are viewing Section 26: 341: How to find your database name for PrestaShop 1.5
Section 25: 342: Restoring a database backup in PrestaShop 1.5
Section 27: 340: Making a mass price change for PrestaShop using phpMyAdmin

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!
Ask a Question

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Post a Comment

Email Address:
Phone Number:

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

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


Ask the Community!

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

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!