{"id":3975,"date":"2020-03-05T23:44:52","date_gmt":"2020-03-05T23:44:52","guid":{"rendered":"https:\/\/lamp.ciscoar.com\/?page_id=3975"},"modified":"2020-05-19T12:13:58","modified_gmt":"2020-05-19T12:13:58","slug":"integrating-mariadb-with-wordpress","status":"publish","type":"page","link":"https:\/\/lamp.ciscoar.com\/?page_id=3975","title":{"rendered":"Integrating MariaDB with WordPress"},"content":{"rendered":"\n\n\n<h2 class=\"wp-block-heading\">Prerequisite<\/h2>\n\n\n\n<p>The only prerequisite before starting with the integration between the MariaDB database recently created and WordPress is to be sure You actually have WordPress correctly installed and its folders and files already set with proper <a href=\"\/installing-wordpress\/#Setting_ownership_and_permissions\" target=\"_blank\" rel=\"noreferrer noopener\">Ownership and Permissions<\/a>.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"\/installing-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">Installing WordPress<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">The &#8220;wp-config-sample.php&#8221; file<\/h2>\n\n\n\n<p>One of the most important files included in wordpress is the one called &#8220;<strong>wp-config-sample.php<\/strong>&#8221; as its name states this file is a sample that can be copied\/duplicated and modify accordingly to our particular configuration.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Duplicating the sample file<\/h2>\n\n\n\n<p>Duplicating files is the perfect job for WinSCP.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"504\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/duplicating-wordpress-sample-file-using-winscp.gif\" alt=\"\" class=\"wp-image-3976\"\/><figcaption>duplicating wordpress sample file<\/figcaption><\/figure><\/div>\n\n\n\n<p>The animation above shows how to duplicate the sample file and in the process also to rename the file to its final name &#8220;<strong>wp-config.php<\/strong>&#8220;.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Modifying &#8220;wp-config.php&#8221; file<\/h2>\n\n\n\n<p>On the image below you can see highlighted the three variables&#8217; values you must complete in order to integrate WordPress with the <a rel=\"noreferrer noopener\" aria-label=\"database previously created (opens in a new tab)\" href=\"\/creating-a-new-mysql-maria-data-base\/\" target=\"_blank\">database previously created<\/a>, remember that we&#8217;re using the user &#8220;root&#8221; only because we are working on a LAB environment.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php_.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"593\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php_.jpg\" alt=\"\" class=\"wp-image-3988\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php_.jpg 630w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php_-300x282.jpg 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>The image below shows how should look like the &#8220;wp-config.php&#8221; file.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php-02.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"617\" height=\"397\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php-02.jpg\" alt=\"\" class=\"wp-image-3994\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php-02.jpg 617w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/03\/adapting-modifying-wp-config.php-02-300x193.jpg 300w\" sizes=\"auto, (max-width: 617px) 100vw, 617px\" \/><\/a><figcaption>wp-config.php<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Where to go next?<\/h2>\n\n\n\n<p>Everything was configured for WordPress to be open for the first time, you will be asked for a few more settings before getting to the final wordpress login page.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"\/opening-wordpress-for-the-first-time\/\">Opening WordPress for first time<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Prerequisite The only prerequisite before starting with the integration between the MariaDB database recently created and WordPress is to be sure You actually have WordPress correctly installed and its folders and files already set with proper Ownership and Permissions. Installing WordPress The &#8220;wp-config-sample.php&#8221; file One of the most important files included in wordpress is the &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/lamp.ciscoar.com\/?page_id=3975\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Integrating MariaDB with WordPress&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3975","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3975"}],"version-history":[{"count":14,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3975\/revisions"}],"predecessor-version":[{"id":5384,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3975\/revisions\/5384"}],"wp:attachment":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}