Install WordPress on Debian 12 (Nginx + PHP-FPM + MySQL)

Prerequisites

• Nginx · PHP-FPM · MySQL

Step 1 – Database

CREATE DATABASE wordpress CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'WPStrongPass!';
GRANT ALL PRIVILEGES ON wordpre...

Install WordPress on Gentoo Linux (Nginx + PHP-FPM + MySQL)

Prerequisites

• Nginx · PHP-FPM · MySQL

Step 1 – Database

CREATE DATABASE wordpress CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'WPStrongPass!';
GRANT ALL PRIVILEGES ON word...

Install WordPress on NetBSD 10 (Nginx + PHP-FPM + MySQL)

Prerequisites

• Nginx · PHP-FPM · MySQL

Step 1 – Database

CREATE DATABASE wordpress CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'WPStrongPass!';
GRANT ALL PRIVILEGES ON wordpre...

Install WordPress on OpenBSD 7.5 (Nginx + PHP-FPM + MySQL)

Prerequisites

• Nginx · PHP-FPM · MySQL

Step 1 – Database

CREATE DATABASE wordpress CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'WPStrongPass!';
GRANT ALL PRIVILEGES ON wordp...

Install WordPress on RHEL 9 (Nginx + PHP-FPM + MySQL)

Prerequisites

• Nginx · PHP-FPM · MySQL

Step 1 – Database

CREATE DATABASE wordpress CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'WPStrongPass!';
GRANT ALL PRIVILEGES ON wordpress....

Install WordPress on Ubuntu 24.04 (Nginx + PHP-FPM + MySQL)

Prerequisites

• Nginx · PHP-FPM · MySQL

Step 1 – Database

CREATE DATABASE wordpress CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'WPStrongPass!';
GRANT ALL PRIVILEGES ON word...

Integrate PHP-FPM with Nginx on AlmaLinux 9

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /run/php-fpm/www.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index.php...

Integrate PHP-FPM with Nginx on Arch Linux

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /run/php-fpm/php-fpm.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index....

Integrate PHP-FPM with Nginx on Debian 12

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /run/php/php8.2-fpm.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index.ph...

Integrate PHP-FPM with Nginx on Gentoo Linux

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /var/run/php-fpm.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index.ph...

Integrate PHP-FPM with Nginx on NetBSD 10

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /var/run/php-fpm.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index.php i...

Integrate PHP-FPM with Nginx on OpenBSD 7.5

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /var/run/php-fpm.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index.php...

Integrate PHP-FPM with Nginx on RHEL 9

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /run/php-fpm/www.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index.php inde...

Integrate PHP-FPM with Nginx on Ubuntu 24.04

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /run/php/php8.3-fpm.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index...

Configure Postfix or OpenSMTPD to send and receive email securely.

Install MariaDB, set up a Galera multi-master cluster, back up and tune performance.

MariaDB Backup and Restore on AlmaLinux 9

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Maria

MariaDB Backup and Restore on Arch Linux

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mariab

MariaDB Backup and Restore on Debian 12

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mariaba

MariaDB Backup and Restore on Gentoo Linux

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mari

MariaDB Backup and Restore on NetBSD 10

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mariaba

MariaDB Backup and Restore on OpenBSD 7.5

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Maria

MariaDB Backup and Restore on RHEL 9

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mariabacku

MariaDB Backup and Restore on Ubuntu 24.04

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mari