Database

How to Configure PHP-FPM with Nginx on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Install Drupal 11 on Ubuntu 26.04

Drupal 11 is the latest release of the enterprise-grade content management framework. Built on PHP 8.3+, it introduces Starshot initiative improvements and a modernised admin experience. This guide installs Drupal 11 on Ubuntu 26.04 LTS with Nginx, PHP 8.4, and MySQL 9. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Ubuntu 26.04 LTS with Nginx, […]

Read more
How to Configure PHP-FPM with Nginx on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Install CodeIgniter 4 on Ubuntu 26.04

CodeIgniter 4 (CI4) is a lightweight PHP framework with a small footprint, excellent documentation, and a gentle learning curve. It is ideal for developers who want a fast, simple MVC framework without heavy dependencies. This guide deploys CodeIgniter 4 on Ubuntu 26.04 LTS with Nginx and PHP 8.4. Tested and valid on: Ubuntu 26.04 LTS […]

Read more
How to Secure MySQL 9 on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Install phpMyAdmin on Ubuntu 26.04

phpMyAdmin is a browser-based MySQL and MariaDB administration tool. It provides a graphical interface for managing databases, running SQL queries, importing/exporting data, and managing users — all without the command line. This guide installs and secures phpMyAdmin on Ubuntu 26.04 LTS. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Ubuntu 26.04 LTS with Apache and […]

Read more
How to Secure MySQL 8.0 on Ubuntu 24.04 — step-by-step Linux tutorial on Progressive Robot

How to Configure MySQL Primary-Replica Replication on Ubuntu 24.04

MySQL replication keeps a replica server in sync with a primary, providing redundancy and read scaling. This guide configures MySQL 8.0 primary-replica (master-slave) replication between two Ubuntu 24.04 LTS servers. Tested and valid on: Ubuntu 24.04 LTS Prerequisites Two Ubuntu 24.04 LTS servers (primary and replica) with MySQL 8.0 installed Network connectivity between the two […]

Read more
How to Secure MySQL 9 on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Configure MySQL Primary-Replica Replication on Ubuntu 26.04

MySQL primary-replica replication asynchronously copies data from a primary server to one or more replica servers. This improves read scalability, provides a hot standby for disaster recovery, and enables backups from the replica without impacting the primary. This guide sets up replication on Ubuntu 26.04 LTS. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Two […]

Read more
How to Secure MySQL 8.0 on Ubuntu 24.04 — step-by-step Linux tutorial on Progressive Robot

How to Back Up and Restore MySQL Databases on Ubuntu 24.04

Regular database backups are essential. This guide covers multiple methods for backing up and restoring MySQL 8.0 databases on Ubuntu 24.04 LTS — from simple mysqldump exports to automated cron jobs. Tested and valid on: Ubuntu 24.04 LTS Prerequisites Ubuntu 24.04 LTS server with MySQL 8.0 installed A user with sudo privileges Step 1 – […]

Read more
How to Secure MySQL 9 on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Back Up and Restore MySQL Databases on Ubuntu 26.04

Regular database backups are essential for disaster recovery. MySQL provides several tools — mysqldump for logical backups, mysqlpump for parallel dumps, and MySQL Shell’s dumpInstance for modern cloud-friendly backups. This guide covers backing up and restoring MySQL databases on Ubuntu 26.04 LTS. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Ubuntu 26.04 LTS with MySQL […]

Read more
How to Secure MySQL 8.0 on Ubuntu 24.04 — step-by-step Linux tutorial on Progressive Robot

How to Secure MySQL 8.0 on Ubuntu 24.04

A default MySQL 8.0 installation has several security weaknesses that should be addressed before going to production. This guide walks through MySQL hardening best practices on Ubuntu 24.04 LTS. Tested and valid on: Ubuntu 24.04 LTS Prerequisites Ubuntu 24.04 LTS server with MySQL 8.0 installed A user with sudo privileges Step 1 – Run mysql_secure_installation […]

Read more
How to Secure MySQL 9 on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Install pgAdmin 4 on Ubuntu 26.04

pgAdmin 4 is the most popular open-source administration and development tool for PostgreSQL. It provides a web-based interface for managing databases, writing queries, monitoring server activity, and managing schemas. This guide installs pgAdmin 4 in web mode on Ubuntu 26.04 LTS. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Ubuntu 26.04 LTS with PostgreSQL 17 […]

Read more
How to Secure MySQL 9 on Ubuntu 26.04 — step-by-step Linux tutorial on Progressive Robot

How to Secure MySQL 9 on Ubuntu 26.04

A default MySQL installation exposes several security risks — anonymous users, a test database, and root remote login. Beyond the initial security script, additional hardening significantly reduces your attack surface. This guide walks through a thorough MySQL 9 security hardening process on Ubuntu 26.04 LTS. Tested and valid on: Ubuntu 26.04 LTS Prerequisites Ubuntu 26.04 […]

Read more
CHAT