OneLinersCommand workbench
Guides
Operational guides

Complete procedures with a way back.

Searchable, versioned procedures with prerequisites, verification, concrete output, and rollback.

Guides
243
Favorites
0
243 launch guides · 2601 reviewed steps
11 of 243 guides

Security · Databases & Data

Configure hostname-verifying TLS for MySQL and MariaDB clients

Issue identities from a trusted CA, protect private keys, require encrypted accounts, configure hostname verification, rotate certificates, and test downgrade resistance.
Save to collectionCreate a collection in the sidebar first.
caution70 minadvanced8 stepsMySQL

Services & Applications · Databases & Data

Install a production LAMP stack on Ubuntu

Build Apache, MariaDB, PHP-FPM, TLS, application identity, database credentials, health checks, and backups as one verified stack.
Save to collectionCreate a collection in the sidebar first.
caution90 minadvanced8 stepsUbuntu Server

Services & Applications · Databases & Data

Install a production LEMP stack on Ubuntu

Build nginx, MariaDB, PHP-FPM, TLS, isolated application paths, FastCGI safety rules, health checks, and backups.
Save to collectionCreate a collection in the sidebar first.
caution90 minadvanced8 stepsUbuntu Server

Security · Databases & Data

Manage MariaDB users, passwords, roles, and rotation safely

Create host-scoped accounts, assign roles, rotate credentials without exposing them in shell history, test grants, and retire access.
Save to collectionCreate a collection in the sidebar first.
caution45 minintermediate8 stepsMariaDB

Databases & Data · Security

Install MariaDB Server with a production baseline

Install MariaDB from an official distribution or MariaDB repository, constrain networking, create an administrator path, enable logs, and prove restart safety.
Save to collectionCreate a collection in the sidebar first.
caution50 minintermediate8 stepsMariaDB

Databases & Data · Backup & Recovery

Back up and restore MariaDB with mariadb-dump

Create a consistent logical backup with routines, events, triggers, metadata, compression, encryption, checksums, retention, and an isolated restore test.
Save to collectionCreate a collection in the sidebar first.
caution75 minadvanced8 stepsMariaDB

Databases & Data · Backup & Recovery

Create and restore a physical backup with mariadb-backup

Install the matching utility, take a streamed or directory backup, prepare redo logs, encrypt and copy it, then restore on an isolated compatible server.
Save to collectionCreate a collection in the sidebar first.
caution100 minadvanced8 stepsMariaDB

Databases & Data · High Availability & Reliability

Configure MariaDB replication with GTID and TLS

Prepare compatible primary and replica servers, create a TLS-bound replication user, seed data, configure GTID replication, monitor lag, and test recovery.
Save to collectionCreate a collection in the sidebar first.
caution120 minadvanced8 stepsMariaDB

Security · Databases & Data

Harden a MariaDB Server for production

Remove anonymous and test access, restrict administration, enforce TLS where remote clients are required, audit grants, and verify exposure.
Save to collectionCreate a collection in the sidebar first.
caution60 minadvanced8 stepsMariaDB

Databases & Data · Security

Install and secure phpMyAdmin behind Apache

Install from a trusted package or verified upstream release, isolate configuration secrets, add TLS and network authentication gates, disable dangerous defaults, and test database TLS.
Save to collectionCreate a collection in the sidebar first.
caution60 minadvanced8 stepsphpMyAdmin

Databases & Data · Security

Install and secure phpMyAdmin behind nginx and PHP-FPM

Deploy phpMyAdmin on an isolated FPM pool, protect it with network and HTTP authentication, verify database TLS, deny unsafe paths, and validate updates.
Save to collectionCreate a collection in the sidebar first.
caution65 minadvanced8 stepsphpMyAdmin