Articles by Dejan Panovski
How to List PostgreSQL Databases and Tables using psql
List PostgreSQL databases and tables from the psql shell using meta-commands and SQL queries.
git cherry-pick Command: Apply Commits from Another Branch
How to use git cherry-pick to apply commits from one branch to another, including single commits, ranges, conflict handling, backports, and merge commits.
Nginx Commands You Should Know
Reference for the most-used Nginx commands on Linux: start, stop, restart, reload, test config, dump config, check version, and read logs with systemd.
How to List Installed Packages on Ubuntu
List, filter, and export installed packages on Ubuntu with apt and dpkg, including how to find package details, manually installed packages, and install history.
How to Reset the MySQL Root Password
Step-by-step instructions for resetting a forgotten MySQL or MariaDB root password on Linux, with modern syntax for MySQL 8.0 and Ubuntu auth_socket notes.
ufw Command in Linux: Uncomplicated Firewall Reference
Reference for the ufw command on Linux, with examples for enabling the firewall, allowing and denying traffic, deleting rules, and managing application profiles.
who Command in Bash: List Logged-In Users
The who command lists currently logged-in users, along with their terminal, login time, and remote host. Use it to see active sessions, system boot time, and the current runlevel.
How to Show/List Users in MySQL
Query the mysql.user table to list all MySQL user accounts, check their privileges with SHOW GRANTS, and see who is currently connected to the server.
How To Delete a Local and Remote Git Branch
Git branches pile up fast after merging. This guide shows you how to delete local and remote branches, clean up stale tracking references, and recover a branch you removed by mistake.
How to Force HTTPS using .htaccess
Redirect all HTTP traffic to HTTPS using Apache .htaccess rewrite rules, with examples for www and non-www domain handling.
Docker Run Command with Examples
Practical examples of docker run covering detached mode, port publishing, volumes, environment variables, restart policies, and interactive shells.
file Command in Linux: Determine File Types
Identify file types from the command line using the Linux file command. Covers basic usage, MIME types, compressed files, symlinks, and the magic database.
Apache Commands: Manage and Troubleshoot Your Web Server
Quick reference for essential Apache commands on Linux. Covers service control, configuration testing, modules, virtual hosts, version info, and log files.
env Command in Linux: Show and Set Environment Variables
The env command prints environment variables and runs programs with a modified environment. This guide covers env syntax, running commands with custom variables, clean environments, and portable shebangs.
How to Upgrade Debian 12 to Debian 13 Trixie
Step-by-step instructions for upgrading Debian 12 Bookworm to Debian 13 Trixie, including sources.list changes, package upgrades, and post-upgrade verification.
Nginx Server Blocks on Ubuntu: Host Multiple Websites
Set up Nginx server blocks on Ubuntu to host multiple websites on a single server, each with its own document root, logs, and configuration.
id Command in Linux: Display User and Group Information
The id command prints real and effective user IDs, group IDs, and supplemental group memberships for any user on a Linux system.
sed Delete Lines: Remove Lines by Number, Pattern, or Range
Remove lines from files with sed using line numbers, patterns, ranges, and regular expressions. Covers preview mode, in-place editing, and common recipes.
w Command in Linux: Show Logged-In Users and Activity
Learn how to use the w command in Linux to see logged-in users, idle time, load averages, and what each user is doing.
sysctl Command in Linux: View and Change Kernel Parameters
Learn how to use the sysctl command to view, set, and persist Linux kernel parameters, with practical examples for common settings.
