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.
Now, Click on the Server tab to see all the server-level settings.
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.
After updating the database information, click on the Save button given on the top-left corner of the page.
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.