Wednesday, July 10, 2013

How to change your Joomla 2.5 database username and password

In Joomla! 2.5 backend, 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 area
  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';
  3. 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';
  4. Save file and refresh your website


Disqus Comments