Articles by Dejan Panovski
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.
SSH Tunnel: Local, Remote, and Dynamic Port Forwarding
SSH tunneling (port forwarding) encrypts and relays TCP traffic through a secure SSH connection. This guide covers local, remote, and dynamic port forwarding with practical examples.
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.
How to Set Environment Variables in Linux
Set, list, and make environment variables permanent in Linux. Covers shell vs environment variables, export, printenv, and persistent config in ~/.bashrc and /etc/profile.
less Command in Linux: Navigate and Search Files
The less command displays file contents one page at a time, with full keyboard navigation, search, and multi-file support. This guide covers the most useful options and commands.
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 Change MySQL User Password
Change a MySQL or MariaDB user password from the mysql shell using ALTER USER. Includes the modern syntax for MySQL 8.0, notes on FLUSH PRIVILEGES, and troubleshooting common errors.
How To Create a Sudo User on Ubuntu
Create a new user on Ubuntu with a home directory and grant sudo privileges using adduser and usermod, so you can run administrative commands without logging in as root.
Setting up an Nginx Reverse Proxy
Configure Nginx as a reverse proxy for HTTP and non-HTTP upstreams. Covers proxy_pass, the proxy_set_header directives you need for client IP, websockets, and TLS termination, and common troubleshooting.
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.
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.
