Your Joomla 2.5 database username and password is stored in a file named configuration.php. If you've changed your database username and password through your Joomla 2.5 web hosting providers control panel, you will need to update your Joomla 2.5 database configuration with the new database credentials. You can make this change in Joomla 2.5 by either editing the configuration.php file directly or you can make the changes from your Joomla 2.5 administrator dashboard.

If you need to know how to change the actual database username and password, you need to contact your Joomla 2.5 host for further help. However, if you've already changed those details and you need to tell Joomla of your new database user and pass, keep reading!

Understanding Joomla 2.5 database login credentials:

Your Joomla 2.5 database login credentials are your database username and your database password. In order for Joomla 2.5 to connect to your database, the following things need to be true:

  1. You (or your Joomla 2.5 hosting provider) need to have created a database for you
  2. Besides having a database, you also need to have a database username and a database password
  3. Finally, your database user needs to have appropraite privileges to access your database

So in summary, you need a database, a database username and password, and your database user needs to have the appropriate privileges to access the database. When we refer to database privilegs, we are referring to MySQL privileges such as SELECT, UPDATE, and DELETE.

To change your Joomla 2.5 database username through your administrator dashboard:

In your Joomla 2.5 dashboard, you only have access to change your database username, you cannot change your database password. If you need to change your database password, continue further down this page to where we show you how to update your configuration.php file.

Updating your database username through the Joomla 2.5 dashboard can be tricky. If you change your database username through your host, you won't be able to log into your admin dashboard as you'll see database errors.

  1. Log into your Joomla 2.5 administrator dashboard
  2. In the top menu, hover over Site and click Global Configuration
  3. There are five tabs at the top: Site, System, Server, Permissions, Text filters. Click the Server tab.
  4. At this time, you'll want to change your database username through your Joomla 2.5 web host's control panel.
  5. After changing your database username through your host's control panel, you can now update it in your Joomla 2.5 administrator screen. Under Database Settings, change the Database Username and then click Save in the top menu.

To change your Joomla 2.5 database username and password by editing your configuration.php file:

  1. Using your favorite editor, open configuration.php. This file is in the top level of your Joomla 2.5 website, so you should not need to navigate to any folders already in your file structure.
  2. The following lines define your Joomla 2.5 database username and file:

    public $user = 'database_user';
    public $password = 'database_pass';

    To update the database username and password, change the values between the single quotes. For example, if you change your database username to newuser and your database password to newpass, the changes would look like this:

    public $user = 'newuser';
    public $password = 'newpass';

  3. Save the changes
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: 200918

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

Joomla Community Google+ Hangout #3

June 3rd, 2014

Thank you @RustyJoomla for letting me speak on the Joomla Community Google+ Hangout!

Click here to watch!

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!