When you install Drupal 7 using the Softaculous installer tool, settings such as the database name are automatically generated for your installation. Although the database name is listed on the installation information page, most people do not keep track of it. Later on, when performing specific maintenance, troubleshooting, or needing to change something that the Drupal back office does not handle, they may need to access the database directly. As most hosting accounts use more than one database, this can be confusing. Below are instructions on how to locate the exact database name used by your Drupal 7 installation.

Finding the database name for your Drupal 7 site

  1. You will first need to log into your cPanel dashboard.
  2. Next, from the cPanel dashboard, locate and enter the File Manager.
  3. Once in the File Manger, locate the root folder for your Drupal application. If you are using Drupal for your main domain, then the folder you want to be in is the public_html folder. If you are using Drupal for an addon domain, then it will be in a subfolder. For instance, if example.com is your addon domain using Drupal then it will be found under the public_html/example.com folder.
  4. Now that you have found the root folder for your Drupal installation, look for the configuration file by going to the sites and then the default folder. For example, for your main domain, you will be under the public_html/sites/default path. Look for the file named settings.php. Highlight the file and click on the Edit icon located in the toolbar across the top of the screen. You will also be presented with an additional popup, click the Edit button on that also to open the file editor.
  5. This brings you to the actual editor so you can see the code and settings Drupal uses. The database settings are found after a giant block of commented text, around line 208. You will see a group of settings, one has the database name. The line appears similar to the one below:
    'database' => 'userna5_drpl123',
    The database name is made with two parts, the username and the actual database name. From the example given above, the username portion is userna5 and the database name is drpl123.
  6. Be sure to note the database name. Write it down in a safe place if desired. This is the name you will look for when you are managing the database via your phpMyAdmin tool.
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 this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Like this Article?

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

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

News / Announcements

WordPress wp-login.php brute force attack
Updated 2014-07-17 06:43 pm EST
Hits: 201638

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

Need more Help?

Search

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: support@InMotionHosting.com
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!