Thursday, April 25, 2019

How to Install MariaDB on RHEL / CentOS 8

This guide has been written to help you install MariaDB on RHEL / CentOS 8. RHEL 8 is distributed with MariaDB 10.3 which is binary-compatible with MySQL. MariaDB 10.3...

How to solve “MySQL server is running with the –secure-file-priv” Error

When starting the mysqld server, you can specify program options in the options file or on the command line. These options are meant to unlock other MySQL features, change variables or...

How to Reset RDS Master User Password on AWS

The Amazon RDS service allows you to reset your database instance master user password using their API. In this guide, I'll walk you through the steps to reset RDS...

How to find database sizes in MySQL/MariaDB Database Server

Are you trying to find which databases in your MySQL/MariaDB database server has large tablespace?. People have varying reasons for finding database sizes in MySQL/MariaDB. It could be for data truncation,...

How to Install PostgreSQL 11 on Debian 9 / Debian 8

In this tutorial, we will cover how to Install PostgreSQL 11 on Debian 9 / Debian 8. PostgreSQL is a powerful, highly-extensible database server written in C. The development of PostgreSQL is under PostgreSQL Global...

Install PostgreSQL 11 on Ubuntu 18.04 / Ubuntu 16.04

This short guide will help you to Install PostgreSQL 11 on Ubuntu 18.04 / Ubuntu 16.04. PostgreSQL Server is a robust open source and highly-extensible database server. PostgreSQL provides object-relational database system allowing...

How to Install MySQL 8.0 on Debian 9 / Debian 8

This tutorial has been written to help you install MySQL 8.0 on Debian 9 / Debian 8. This guide is for a fresh installation of MySQL 8.0 on Debian 9 / Debian...

Installing MongoDB 4.0 on CentOS 7 / Fedora 29 / Fedora 28

Welcome to our guide on how to install MongoDB 4.0 on CentOS 7 / Fedora 29 / Fedora 28. MongoDB is an open source NoSQL database system written in C++. It...

How to install Microsoft SQL Server 2019 on CentOS 7 / Fedora

SQL Server runs on Linux starting with SQL Server 2017. This SQL Server is the same SQL Server database engine running on Microsoft Operating systems, with many similar features...

How to Install pgAdmin 4 on CentOS 7 / Fedora 29

pgAdmin is the leading Open Source feature-rich PostgreSQL administration and development platform that runs on Linux, Unix, Mac OS X, and Windows. pgAdmin can be used to manage PostgreSQL 9.2...