305: How to Change your Joomla 3.0 Database SettingsWritten by Brad Markle
In our last tutorial, we showed you how having the wrong database credentials in your Joomla 3.0 configuration.php file can cause the Error displaying the error page: Application Instantiation Error. To resolve this database error, you need to confirm that your database credentials with your hosting provider match those set within your Joomla configuration file.
In this tutorial, we are going to give you a broad overview of how to ensure your Joomla 3.0 website is connecting successfully to your MySQL database. This article assumes that you are familiar with basic file editing, using a program such as the File Manager (located within cPanel).
To ensure you are using the correct database settings in Joomla 3.0:
- Review the database settings you are currently using
Using an editor of your choice and open your Joomla configuration.php file. This file will be located in the top level of your Joomla 3.0 files on your server. When you open the file, pay attention to the following settings:
public $host = 'localhost'; public $user = 'juser'; public $password = 'jpass'; public $db = 'jdb';
As you can see in the above, my database server is localhost. I am connecting to a database named jdb, with juser and jpass as the database username and password.
- Confirm with your Joomla Hosting provider your settings are correct
Most hosting providers will give you an interface where you can setup databases. If you're familiar with their tools, confirm that the database settings you are using in your Joomla configuration.php file match what is set on the server. If you can't see the password set on the server, reset it so you can be sure you are using the correct database password. If you need any assistance, contact your host's technical support for further assistance.
- If needed, update the database settings in Joomla's configuration.php file
The key to connecting Joomla 3.0 to your database successfully is knowing what your database settings actually are on your server, and then making sure they match within Joomla's configuration.php file. For example, if you reset your database password on the server in step 2 above, be sure to update the password in your configuration file as well.