MySQL
How to Install MySQL 5.6.15 on CentOS 6 and RHEL 6
Hi Guys, This tutorial will help to for installing MySQL 5.6 on CentOS/RHEL system. I am using CentOS 6, 32…
Category: Databases
Databases
SQLite3 SQL Command Uses with Examples
SQLite is a lightweight SQL database that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. Except some of the…
MySQL
Setting Up Nginx + MariaDB + PHP-FPM on CentOS/RHEL 9/8
Introduction The LEMP stack, consisting of Linux, Nginx, MariaDB, and PHP-FPM, is a powerful combination for hosting dynamic websites and…
PostgreSQL
How to Install phpPgAdmin on CentOS & RHEL using Yum
phpPgAdmin is web-based client written in php for accessing and managing PostgreSQL databases. It provides very efficient way to work…
MySQL
How To Create a New User and Grant Permissions in MySQL
MySQL is a relational database management system, used for storing data in form of tables and records. You can insert,…
SQL Server
How to Shrink SQL Server Transaction Log Files using DBCC SHRINKFILE
Sometimes SQL Server logs files acquire a large space on the disk. In that case, we need to reduce the…
MariaDB
MySQL Database Backup to FTP Server – Shell Script
As a system administrator, you need to take backup on daily basis. Backups are very useful to recover data from…
MySQL
How to Reset MySQL Root Password in Linux
Resetting the MySQL root password in Linux is a crucial task for database administrators, especially when access is lost or…
MariaDB
How to Backup and Restore MySQL Databases Efficiently
MySQL is one of the most popular open-source relational database management systems used worldwide. As your data grows, it becomes…