{"id":3662,"date":"2016-04-06T12:24:28","date_gmt":"2016-04-06T12:24:28","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=3662"},"modified":"2021-02-06T05:03:59","modified_gmt":"2021-02-06T05:03:59","slug":"magento-2-database-configuration-file","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/","title":{"rendered":"Magento 2 Database Configuration File"},"content":{"rendered":"

As Magento2 has recently launched and most of the people ask about its database configuration when migrate on Magento2,So In this tutorial we will give you details about Magento 2 configuration file.<\/span><\/p>\n

In Magento 1.0, the configuration file is available in:<\/span><\/p>\n

\n
\/app\/etc\/local.xml<\/pre>\n<\/div>\n
In Magneto2 configuration file is in same directory but has been renamed with env.php.<\/span><\/p>\n
The file path is as follows:<\/span><\/p>\n
\n
\/app\/etc\/env.php<\/pre>\n<\/div>\n
In this file many other configuration variables include like you can change the database table prefix as it\u2019s very helpful if you want to use single database for multiple installations like WordPress, Joomla etc.\u00a0<\/span><\/p>\n
\n
'db'=>\u00a0\u00a0\u00a0\r\narray\u00a0(\u00a0\u00a0\r\n'table_prefix'\u00a0=>\u00a0'',\u00a0\u00a0\r\n'connection'\u00a0=>\u00a0\u00a0\u00a0\r\narray\u00a0(\u00a0\u00a0\r\n'default'\u00a0=>\u00a0\u00a0\u00a0\r\narray\u00a0(\u00a0\u00a0\r\n'host'\u00a0=>\u00a0'localhost',\u00a0\u00a0\r\n'dbname'\u00a0=>\u00a0'magento2',\u00a0\u00a0\r\n'username'=>\u00a0'root',\u00a0\u00a0\r\n'password'=>\u00a0'YOUR_DB_PASSWORD',\u00a0\u00a0\r\n'active'=>\u00a0'1',\u00a0\u00a0\r\n),\u00a0\u00a0\r\n),\u00a0\u00a0\r\n),<\/pre>\n<\/div>\n
Also in this file you can define the admin panel URL, by default its admin but you can change it so that hackers can\u2019t access it easily.<\/span><\/p>\n
\n
'backend' =>   \r\narray (  \r\n'frontName' => 'admin',  \r\n),  \r\n<\/pre>\n<\/div>\n
Magento 2 also allows you to specify what types of caching are enabled in the system by changing values in configuration file.<\/span><\/p>\n
\n
'cache_types'=>\u00a0\u00a0\u00a0\r\narray\u00a0(\u00a0\u00a0\r\n'config'\u00a0=>\u00a01,\u00a0\u00a0\r\n'layout'\u00a0=>\u00a01,\u00a0\u00a0\r\n'block_html'\u00a0=>\u00a01,\u00a0\u00a0\r\n'collections'\u00a0=>\u00a01,\u00a0\u00a0\r\n'db_ddl'\u00a0=>\u00a01,\u00a0\u00a0\r\n'eav'\u00a0=>\u00a01,\u00a0\u00a0\r\n'full_page'\u00a0=>\u00a01,\u00a0\u00a0\r\n'translate'=>\u00a01,\u00a0\u00a0\r\n'config_integration'=>\u00a01,\u00a0\u00a0\r\n'config_integration_api'=>\u00a01,\u00a0\u00a0\r\n'config_webservice'=>\u00a01,\u00a0\u00a0\r\n)<\/pre>\n<\/div>\n
That\u2019s all about Magento2 database configuration file.<\/span><\/p>\n
Give your opinion below if you experience any issues or to discuss your ideas and experiences.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
As Magento2 has recently launched and most of the people ask about its database configuration when migrate on Magento2,So In this tutorial we will give you details about Magento 2 configuration file. […]<\/p>\n
Continue Reading…<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,14],"tags":[],"class_list":["post-3662","post","type-post","status-publish","format-standard","hentry","category-cpanel","category-linux"],"yoast_head":"\nMagento 2 Database Configuration File - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Magento 2 Database Configuration File - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"As Magento2 has recently launched and most of the people ask about its database configuration when migrate on Magento2,So In this tutorial we will give you details about Magento 2 configuration file. [...]Continue Reading...\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"Magento 2 Database Configuration File\",\"datePublished\":\"2016-04-06T12:24:28+00:00\",\"dateModified\":\"2021-02-06T05:03:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/\"},\"wordCount\":173,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"articleSection\":[\"Cpanel\",\"Linux\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/\",\"name\":\"Magento 2 Database Configuration File - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"datePublished\":\"2016-04-06T12:24:28+00:00\",\"dateModified\":\"2021-02-06T05:03:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Magento 2 Database Configuration File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Magento 2 Database Configuration File - cPanel Plesk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/","twitter_card":"summary_large_image","twitter_title":"Magento 2 Database Configuration File - cPanel Plesk","twitter_description":"As Magento2 has recently launched and most of the people ask about its database configuration when migrate on Magento2,So In this tutorial we will give you details about Magento 2 configuration file. [...]Continue Reading...","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"Magento 2 Database Configuration File","datePublished":"2016-04-06T12:24:28+00:00","dateModified":"2021-02-06T05:03:59+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/"},"wordCount":173,"commentCount":0,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"articleSection":["Cpanel","Linux"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/","url":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/","name":"Magento 2 Database Configuration File - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"datePublished":"2016-04-06T12:24:28+00:00","dateModified":"2021-02-06T05:03:59+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/magento-2-database-configuration-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"Magento 2 Database Configuration File"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/3662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=3662"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/3662\/revisions"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=3662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=3662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=3662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}