Tagged articles
Database Installation
14 articles · Page 1 of 1
This guide provides a comprehensive, step‑by‑step shell script that automates the installation, configuration, and service setup of MySQL 8.4 from source on a wide range of Linux distributions, including Rocky, AlmaLinux, CentOS, openEuler, Anolis, OpenCloudOS, Kylin, UOS, openSUSE, Ubuntu, and Debian.
Database InstallationLinuxMySQL
0 likes · 25 min read

This comprehensive tutorial walks you through installing MySQL on AlmaLinux, covering prerequisite cleanup, official repository setup, secure configuration, service management, and an optional Docker‑Compose deployment, plus tips for connecting with DataGrip.
AlmaLinuxDataGripDatabase Installation
0 likes · 12 min read


ITPUBSep 4, 2024 · Databases
This article introduces SQLite, explains why it is the most widely deployed lightweight SQL engine, outlines its common use cases in mobile, desktop and IoT devices, compares it with MySQL and PostgreSQL, and provides step‑by‑step installation instructions.
Database InstallationSQLiteembedded database
0 likes · 6 min read


ITPUBMay 27, 2024 · Databases
This article compiles over a decade of real‑world Oracle single‑instance and RAC deployment experiences, detailing compatibility issues, specific bugs encountered in versions 10g, 11g, 12c, 19c on Linux platforms, and step‑by‑step remediation commands, scripts, and configuration adjustments to ensure successful installation.
Database InstallationLinuxOracle
0 likes · 13 min read

This tutorial walks you through installing the Aerospike NoSQL database, tuning Linux system parameters, configuring a three‑node cluster, performing basic AQL operations, and setting up AMC monitoring, all within roughly ten minutes of setup time.
AerospikeCluster SetupDatabase Installation
0 likes · 11 min read

This comprehensive tutorial walks through preparing the environment, configuring yum repositories and hosts, installing Oracle Grid Infrastructure with ASM disk groups, creating ASM disks, and finally building an Oracle database on a CentOS 7 system, including command examples and GUI steps.
ASMCentOSDatabase Installation
0 likes · 5 min read

This comprehensive tutorial walks you through preparing the environment, configuring the OS, setting up ASM disk groups, installing Oracle Grid Infrastructure, creating ASM disks, and building a database on a CentOS 7 cluster, complete with detailed screenshots for each step.
ASMCentOSCluster
0 likes · 7 min read

Learn how to completely uninstall any existing MySQL, install MySQL 8.0 via dnf or yum, verify the installation, configure it to start on boot, manage root passwords, and set up remote access with Navicat, all with clear commands and screenshots.
Database InstallationLinuxMySQL
0 likes · 6 min read

This guide walks you through installing SQLite, using a graphical management tool, understanding its data types and keywords, and performing core database operations such as creating, viewing, exporting, attaching, and detaching databases, all with practical command‑line examples and screenshots.
Database InstallationGUI ToolSQL commands
0 likes · 9 min read

This article walks through a real‑world Oracle 19c RAC deployment on Red Hat 7.6, detailing the root.sh failure caused by a missing IPv6 ::1 entry, patch installation errors due to file permission problems, and step‑by‑step IPv6 network configuration to get the database fully operational.
19cDatabase InstallationIPv6
0 likes · 7 min read

This article provides a comprehensive, ordered tutorial for preparing the environment, configuring the root and oracle users, adjusting kernel and system limits, and finally installing and initializing Oracle 12c on a Linux server using detailed command‑line instructions.
Database InstallationLinuxOracle
0 likes · 5 min read

This tutorial walks you through installing MySQL on Ubuntu, covering command‑line installation, password configuration, service verification, and basic usage, all illustrated with screenshots to make the process clear and straightforward.
Database InstallationLinuxMySQL
0 likes · 4 min read

This guide walks you through installing MariaDB via binary packages, explains its configuration file hierarchy, demonstrates essential client and server commands for data definition and manipulation, and details how to create users and manage their privileges effectively.
DDLDMLDatabase Installation
0 likes · 8 min read

This comprehensive guide explains what databases are, their evolution, key models, core DBMS components, and provides step‑by‑step instructions for installing, configuring, and securing MySQL on Linux, along with essential SQL commands and concepts.
DBMSDatabase InstallationLinux
0 likes · 18 min read
