Articles by Dejan Panovski
Install RPM packages on Ubuntu
Install RPM packages on Ubuntu with alien by converting an `.rpm` file to a `.deb` package or installing it directly.
How to Count Files in a Directory in Linux
Several ways to count files in a directory in Linux using the ls, find, and tree commands, with examples for counting files recursively.
Basic Linux Commands Every User Should Know
The basic Linux commands you need for file management, navigation, permissions, networking, and package management, with practical examples for beginners and system administrators.
Bash Heredoc: Complete Guide with Examples
Bash heredoc lets you pass multi-line text directly to a command inside a shell script. This guide covers syntax, variable expansion, indentation with <<-, SSH usage, and common mistakes.
Tcpdump Command in Linux
tcpdump is the standard command-line packet analyzer for Linux. This guide covers capturing traffic, filtering by host and port, reading output, and saving captures to a file.
How to Use the gunzip Command in Linux
The gunzip command decompresses .gz files on Linux. This guide covers the most common options with practical examples.
How to Check the PostgreSQL Version
Check the PostgreSQL server version from the command line with postgres --version, or from within a database session using SELECT version() or SHOW server_version. You can also check the psql client version separately.
How to Check the PHP Version
Two ways to check which PHP version is running on your server: the phpinfo() function from the browser, and the php --version command from the terminal.
PostgreSQL User Management: Create Users and Grant Privileges
Step-by-step instructions for creating PostgreSQL users (roles), setting passwords, and granting or revoking privileges on databases, schemas, and tables.
How to Create MySQL User Accounts and Grant Privileges
Create MySQL user accounts, grant or revoke privileges, and manage access on MySQL 8 and MariaDB with the commands in this guide.
How to Change the SSH Port in Linux
Change the default SSH port 22 by editing sshd_config, adjusting the firewall, and reloading the SSH service on Linux.
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 Check the Kernel Version in Linux
Three quick ways to find the Linux kernel version from the command line: uname, hostnamectl, and /proc/version.
