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
12 of 243 guides

Databases & Data · Networking & DNS · Incident Response & Troubleshooting

Fix MySQL ERROR 2002 and ERROR 2003 connection failures

Diagnose MySQL ERROR 2002 and ERROR 2003 without guessing: separate a missing or mismatched Unix socket from a stopped service, wrong TCP port, bind-address policy, DNS, firewall, route, and certificate-verified TLS failure.
Save to collectionCreate a collection in the sidebar first.
caution55 minintermediate10 stepsMySQL Community Server

Databases & Data · Identity & Access · Incident Response & Troubleshooting

Fix MySQL ERROR 1045 Access denied for user

Diagnose MySQL ERROR 1045 by proving the selected server, transport, client origin, matching user@host account, authentication plugin, lock state, password state, and TLS policy before changing credentials or grants.
Save to collectionCreate a collection in the sidebar first.
caution40 minintermediate8 stepsMySQL Server

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

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

Security · Databases & Data

Manage MySQL 8.4 users, passwords, roles, and rotation

Create source-scoped accounts, use roles, enforce TLS and password policy, rotate without command-line leakage, test denial, and retire access.
Save to collectionCreate a collection in the sidebar first.
caution50 minintermediate8 stepsMySQL

Databases & Data

Back up, restore, and test a MySQL database

Create a consistent logical backup, restore it into isolation, verify representative data, and retain evidence.
Save to collectionCreate a collection in the sidebar first.
caution45 minintermediate9 stepsMySQL Community Server

Databases & Data · High Availability & Reliability

Configure MySQL 8.4 GTID replication with TLS

Prepare source and replica identities, enable GTIDs and binary logs, seed from a verified backup, require TLS, start replication, and test lag and restart.
Save to collectionCreate a collection in the sidebar first.
caution120 minadvanced8 stepsMySQL

Databases & Data · Security

Install and secure MySQL on Ubuntu

Install MySQL, remove unsafe defaults, create a least-privilege application database, optionally allow restricted TLS network access, and prove backup readiness.
Save to collectionCreate a collection in the sidebar first.
caution45 minintermediate12 stepsUbuntu Server

Databases & Data · Backup & Recovery

Back up and restore MySQL 8.4 with a logical dump

Define recovery objectives, create a least-privilege backup identity, capture schemas and objects consistently, encrypt offsite, and run an isolated restore test.
Save to collectionCreate a collection in the sidebar first.
caution80 minadvanced8 stepsMySQL

Observability & Monitoring · Databases & Data

Enable and analyze the MySQL slow query log safely

Baseline workload, enable bounded slow logging, protect and rotate files, summarize candidates, use EXPLAIN ANALYZE carefully, and prove improvement.
Save to collectionCreate a collection in the sidebar first.
caution75 minadvanced8 stepsMySQL

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