Automating MySQL Operations with Shell Scripts

MariaDB Installation yum install mariadb mariadb-server mariadb-libs -y systemctl start mariadb netstat -tnlp | grep :3306 MariaDB runs without a default password, allowing direct access via the mysql command. Database Setup CREATE DATABASE school DEFAULT CHARACTER SET utf8; Table Definitions CREATE TABLE student ( s_id VARCHAR(20), s ...

Posted on Tue, 23 Jun 2026 17:47:34 +0000 by IAK

Mastering Zabbix: Comprehensive Deployment, Agent Management, and Advanced Monitoring Architectures

System Baseline & Environment Hardening Before deploying the monitoring stack, ensure the operating environment meets minimum requirements and security baselines. Synchronize system clocks, disable interference services, and verify network reachability. # Verify release version and kernel architecture cat /etc/redhat-release uname -r # Tem ...

Posted on Thu, 28 May 2026 22:01:40 +0000 by camdenite

Manual WordPress Deployment on Rocky Linux 8.9 with LAMP Stack

Environment Setup Rocky Linux 8.9 is used as the depolyment environment. Install Apache, MariaDB, and PHP manually. Disable SELinux and firewalld for testing purposes: # Set SELinux to permissive mode temporarily setenforce 0 # Disable firewalld systemctl stop firewalld systemctl disable firewalld Apache Configuration Installation yum install ...

Posted on Wed, 20 May 2026 01:59:38 +0000 by fragger

Installing MariaDB on Ubuntu Systems

MariaDB Installation Process Execute the following command to install both server and client components: sudo apt-get install mariadb-server mariadb-client Verifying Installation Status Checking Version mysql --version Example output: mysql Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64) Checking Service Status sudo service m ...

Posted on Sun, 17 May 2026 05:44:59 +0000 by TheFilmGod

Understanding and Implementing Zabbix for System Monitoring

Zabbix is an enterprise-grade open-source monitoring solution renowned for its ability to track the performance and availability of servers, networks, and applications. Before delving into Zabbix's specifics, it's beneficial to understand foundational monitoring concepts, particularly the Simple Network Management Protocol (SNMP), and to compar ...

Posted on Fri, 15 May 2026 19:27:38 +0000 by Marc