How to change your Joomla 2.5 database username and password

Joomla 2.5 has reached its end of life as for 12/31/2014. Please be advised this may be a security risk to your website. You can view more information about the end of life here.

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:

You (or your Joomla 2.5 hosting provider) need to have created a database for you

Besides having a database, you also need to have a database username and a database password

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.

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.

There are five tabs at the top: Site, System, Server, Permissions, Text filters. Click the Server tab.

At this time, you'll want to change your database username through your Joomla 2.5 web host's control panel.

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 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: