Magento 2 Database Configuration File

Magento 2 is latest version available of the popular eCommerce software Magento. In previous tutorial you got details about Magento2 installation on Linux. This tutorial you will get details about Magento 2 database configuration file. In older version database configuration file was app/etc/local.xml but in Magento2 this configuration is located in app/etc/env.php.

Magento 2 Database Configuration File

To change your Magento 2 database server hostname, database username, password or database name, you need to edit below file.

/<Magento Install Dir>/app/etc/env.php

Navigate to your Magento 2 installation directory and edit app/etc/env.php configuration file in your favorite editor and search for following settings and do necessary changes.

  'db' =>
  array (
    'table_prefix' => '',
    'connection' =>
    array (
      'default' =>
      array (
        'host' => 'localhost',
        'dbname' => 'database_name',
        'username' => 'database_username',
        'password' => 'database_password',
        'active' => '1',
      ),
    ),
  ),

Now update the orange highlighted values as following

• localhost : MySQL server hostname.
• database_username : MySQL user to connect database server.
• database_password : MySQL user password .
• database_name : MySQL database name of magento.