Integrating MariaDB with WordPress


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.

The “wp-config-sample.php” file

One of the most important files included in wordpress is the one called “wp-config-sample.php” as its name states this file is a sample that can be copied/duplicated and modify accordingly to our particular configuration.

Duplicating the sample file

Duplicating files is the perfect job for WinSCP.

duplicating wordpress sample file

The animation above shows how to duplicate the sample file and in the process also to rename the file to its final name “wp-config.php“.

Modifying “wp-config.php” file

On the image below you can see highlighted the three variables’ values you must complete in order to integrate WordPress with the database previously created, remember that we’re using the user “root” only because we are working on a LAB environment.

The image below shows how should look like the “wp-config.php” file.


Where to go next?

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.