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 will help you to update Magento 2 database configuration file. The previous Magento versions’ uses app/etc/local.xml database configuration file. The Magento2 keep database configuration under app/etc/env.php file.
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.
/Magento2 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.
Conclusion
In this tutorial, you have learned to update database configuration on Magento2 application.
Thanks for sharing all of your experiences!
Hello Rahul,
Using same way, can we connect 3rd party SOAP API’s ? Where my credentials are stored in env.php file and using that I will create on connection class like AbstractDB in default Magento2
thanks
Are the passwords in the file encrypted/hashed or are they just stored as plain text?
I am trying to retrieve my password from the env.php file but it does not seem to be correct