Setting up MariaDB Egg for WordPress

This guide will help you configure a MariaDB database for your WordPress installation.

About the Technologies

WordPress is a free and open-source content management system (CMS) written in PHP. It's one of the most popular website creation tools, powering over 40% of all websites on the internet.

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system. It's designed to be highly compatible with MySQL while offering additional features and improved performance.

Database Setup Commands

Run the following SQL commands in your MariaDB console to set up the database for WordPress:

CREATE DATABASE wordpress;

CREATE USER "your_username"@"your_allowed_ipaddr" IDENTIFIED BY "your_password";

GRANT ALL PRIVILEGES ON wordpress.* TO "your_username"@"your_allowed_ipaddr";

FLUSH PRIVILEGES;

Configuration Notes

Port Configuration

Make sure to change your port in .my.cnf to your server port, including the double ticks when executing the command.

IP Address Configuration

Please note that your_allowed_ipaddr is the IP of the node that your WordPress is hosted on. If it's on the same node, use Docker local IP 172.17.0.1.

Example Configuration

CREATE DATABASE wordpress;

CREATE USER "wpuser"@"172.17.0.1" IDENTIFIED BY "SecurePassword123";

GRANT ALL PRIVILEGES ON wordpress.* TO "wpuser"@"172.17.0.1";

FLUSH PRIVILEGES;

References