Threat Picture

Latest Cybersecurity News
Back

Tutorials

21 articles
Date

How to Use Custom HTTP Headers as Nginx Variables

By Charles Joseph • • 4 min read
Every request header can become a variable in your Nginx config. How the conversion works, and what you can do with it, with an example config.
Read More
Illustrated monitor mapping the X-Request-ID header to the Nginx variable $http_x_request_id.

vim: tabstop, shiftwidth, softtabstop, expandtab (Explained)

By Charles Joseph • • 3 min read
Four settings decide what the Tab key actually does in Vim. What each one means, with an example .vimrc and where to find it.
Read More
Watercolor laptop displaying Vim settings for tab width, indentation, and spaces.

How to Rename a MySQL Database (Step by Step)

By Charles Joseph • • 2 min read
There's no RENAME DATABASE command, so you have to be sneaky. Four steps to rename a MySQL database without losing anything.
Read More
Illustrated monitor showing tables moving from old_db to new_db.

How to Get All IP Addresses From a File Using RegEx and PowerShell

By Charles Joseph • • 2 min read
No grep on Windows? A Linux admin's workaround for pulling every unique IP address out of a text file with PowerShell.
Read More
Watercolor laptop with three example IPv4 addresses listed in a PowerShell console.

How to Change Your WordPress URL in MySQL

By Charles Joseph • • 1 min read
Two rows in wp_options decide where your site lives. The SQL to change them when the admin screen isn't an option.
Read More
Illustrated monitor showing the siteurl and home rows in a WordPress options table.

How to Remove EXIF Data From Your Images

By Charles Joseph • • 2 min read
The photo you just posted may carry your home's coordinates. What EXIF data reveals, and how to strip it on Ubuntu and macOS.
Read More
Watercolor camera beside a detached tag marked EXIF.

Hard Links and Symbolic Links, Explained Step by Step

By Charles Joseph • • 6 min read
Create two links to a tiny text file, change its message and watch what happens when its original name disappears.
Read More
Illustrated monitor showing commands to create a hard link and a symbolic link.

How to Get YouTube Thumbnails

By Charles Joseph • • 1 min read
Every YouTube video has thumbnails at several sizes, each at a predictable URL. The list, from 120 by 90 up.
Read More
Illustrated monitor showing three sizes of a video thumbnail from i.ytimg.com.

How to Search Your Entire MySQL Database for a Phrase

By Charles Joseph • • 3 min read
One command finds a phrase anywhere in the database, tested on Ubuntu. The command, a breakdown of each part and the output explained.
Read More
Pen-and-ink monitor showing a database search with two matching cells highlighted.

How to Reset a WordPress User’s Password From Within MySQL

By Charles Joseph • • 1 min read
Locked out of the admin screen? The wp_users table and one SQL command put you back in.
Read More
Illustrated monitor with a masked password cell selected in the WordPress users table.

How to Show the Request and Response Headers in VSCode using the REST Client

By Charles Joseph • • 1 min read
Authentication problems, redirect loops and caching issues all live in the headers. How to see them in VSCode's REST Client.
Read More
Watercolor laptop showing request and response headers in adjacent editor panels.

How to Enable Promiscuous Mode in VMWare Workstation?

By Charles Joseph • • 1 min read
One line in a .vmx file, nearly impossible to find in the docs. How to turn on promiscuous mode for a VMware network card.
Read More
Pen-and-ink Ethernet card with three blue packet traces entering its network port.

Incident Response and Live Forensics on Linux Cheat Sheet

By Charles Joseph • • 3 min read
User accounts, logs, processes, services and files. The commands to run on a Linux box in the first hour of an incident, based on vm32's GitHub repository.
Read More
Illustrated laptop displaying Linux commands for processes, listening ports, and login history.

Incident Response and Live Forensics Cheat Sheet (Linux and Windows Commands Side-By-Side)

By Charles Joseph • • 4 min read
cat /etc/passwd on one side, net user on the other. The incident response commands for Linux and Windows, matched line by line.
Read More
Watercolor reference notebook comparing Linux and Windows commands on facing pages.

How to Import and Export MySQL Databases

By Charles Joseph • • 2 min read
mysqldump out, mysql in. The command-line steps for backing up and restoring databases and single tables.
Read More
Ink-and-watercolor laptop showing a database and SQL file linked by import and export arrows.

How to Filter “access.log” Columns Using AWK

By Charles Joseph • • 2 min read
Nine columns of web server logs, and you only need two. How AWK's FPAT pulls exactly the fields you want.
Read More
Illustrated access-log printout with one column highlighted in pale blue.

MySQL Essentials: A Guide to Key Commands

By Charles Joseph • • 4 min read
Log in without exposing your password, view and create databases, and more. The MySQL commands worth having at your fingertips.
Read More
Ink-and-watercolor monitor displaying three basic MySQL commands.

How to Disable WP Optimize From Creating “wpo-plugins-tables-list.json”

By Charles Joseph • • 2 min read
A popular WordPress plugin quietly lists all your plugins and tables in a public folder. Why that's a problem, and a small custom plugin that stops it.
Read More
Illustrated laptop with a JSON export toggle set to Off.

Developer APIs

By Charles Joseph • • 4 min read
Images, weather, stock trades and PDFs, all free. Forty APIs worth bookmarking, from a video by CodingWithLewis.
Read More
Pen-and-ink laptop displaying an API request and a small JSON response.

Chrome Extension: Remove YouTube Suggestions

By Charles Joseph • • 1 min read
YouTube's suggestions are designed to keep you watching. One small extension removes them, and here's how to install it now that it's gone from the store.
Read More
Watercolor laptop showing a video page with an empty recommendations column.

What the $!$*$@ … Bash Shell Variables

By Charles Joseph • • 4 min read
Follow one script to see how Bash reports arguments, exit status, process IDs, and the previous command’s last argument.
Read More
Ink-and-watercolor laptop displaying Bash commands and an argument count.
Back