Magento 2Magento 2 TutorialsJune 18, 2024Simon Walker

How to Modify Magento 2 Database Configuration file

How to Modify Magento 2 Database Configuration file

When it comes to eCommerce, there are numerous success factors. However, one factor which stands out is a well configured database. Unfortunately, it is also amongst the most ignored factors. Based on our experience as a leading Magento extensions company, most store owners consider product quality, marketing strategies, and pricing to be the most important.

What they fail to realise is that a well-configured database can do wonders for their store’s performance. In this article, our focus is on the Magento database, specifically the Magento database config file. In the previous version of Magento, the database configuration file was app/etc/local.xml, whereas, in Magento 2, the file address is app/etc/env.php

Benefits of a Properly Configured Magento Database Config File

Performance Improvements

The first major benefit of a properly configured database is that it leads to performance improvements as server utilisation is at the optimal level. This improves a store’s loading time and ensures a positive experience for the users. Secondly, it ensures faster data retrieval, thereby allowing tasks to be completed quickly.

Security Enhancement

The database contains sensitive information such as customer order history, payment information, and contact details. If this information is breached, it can easily undermine user trust in the store. Thus, a properly configured database file can easily prevent unauthorised access.


Over the years, your store will likely experience more traffic. When the database is configured properly, its easy for the store to manage this traffic increase without any hassle.

Magento 2 Database Configuration File

You need to edit the file below in order to change the database server hostname, database username, password, or database name in Magento 2.

/<Magento Install Dir>/app/etc/env.php
Find the Magento 2 installation directory with the help of the above link and edit the configuration file that is located on app/etc/env.php. You can continue with the settings and mandatory changes in an editor you like the most.
  'db' =>
array (
    'table_prefix' => '',
    'connection' =>
array (
      'default' =>
array (
        'host' => 'Your MySQL server hostname',
        'dbname' => 'database_name',
        'username' => ''MySQL username server to connect database',
        'password' => 'MYSQL server database password',
        'active' => '1',

Image source: livetiles Don't forget to save changes when you are done.

Final Thoughts on Magento Database Config File

This concludes our article on how to modify the Magento database. If you still have any queries, reach out to our support team .

Read More: