Latest posts
-
Setting up Deploy Key in GitHub to Linux server
1. Generate SSH Key (Deploy Key) Deploy keys are usually read-only (can be made read/write if needed). On your server or machine where deployment will run: When prompted for a passphrase, leave it blank (deploy keys usually must be non-interactive). This generates: 2. Add the Public Key to GitHub Repo 3. Configure Private Key on…
-
Resetting the root password for MariaDB
Pre-requisites: system root access (sudo) 1. Stop the MariaDB/MySQL service (or mysql depending on your installation) 2. Start in safe mode (skip grant tables) This allows you to log in without a password. 3. Log into the database 4. Change the root password For MariaDB 10.4+ (uses mysql_native_password) 5. Exit and restart normally 6. Test…
-
Install PostgreSQL 16 on Debian
To install PostgreSQL 16.9 on Debian, you’ll want to use the official PostgreSQL APT repository, as Debian’s default repositories might not always have the latest version. Here’s a step-by-step guide: Step 1: Add PostgreSQL APT Repository Import the PostgreSQL signing key: Add the repository: Step 2: Install PostgreSQL 16.9 Update your package list: Install PostgreSQL…