How to Change Database Settings in Joomla

Posted on March 16th, 2016

Joomla is an open-source content management system. You can create a custom website or a blog using Joomla. It is built in PHP programming language and it manages all the site’s data in a MySQL database. So, every time you create a Joomla website, you have to connect it with a database that will store all the site’s data.

Unlike any other content management systems, Joomla allows us to update the database settings directly from the admin panel. If you are using CMS like WordPress, you have to update the configuration file directly using FTP or SSH. But with Joomla, the process to change database settings is easy.

This feature is rarely used but comes handy when you migrate your site from one web hosting to another or when you decide to use a remote database or when you want to connect your site with a secondary database. In this tutorial, I am going to show you how to update database settings in Joomla.

Change Database Settings in Joomla

Log in to the admin panel of your Joomla site and click on the System -> Global Configuration option from the top-menu. It will redirect you to a page where you can update all the essential and sensitive settings for your site.

Search engine friendly urls in Joomla

Now, Click on the Server tab to see all the server-level settings.

FTP Settings in Joomla

Under the Server tab, find the Database settings section and enter the updated database information. If you have a second database on the same server, keep the Host the same.

Database Settings

After updating the database information, click on the Save button given on the top-left corner of the page.

Change Database Settings in Joomla

So, this is how you can update database settings in Joomla. It is a very sensitive feature that you should not use if you don’t know what to enter in the form. You also have to make sure that the database is accessible with the new information you are using.

If you have any questions or queries, please let us know in the comment section given below. If you are an active InterServer customer, please contact our support department for the quick help!

One Response to “How to Change Database Settings in Joomla”

  1. Sue Y says:

    How to point the new Database location to Joomla?

Leave a Reply