Database

In this guide, we are going to learn how to install phpMyAdmin on Debian 10 Buster. phpMyAdmin is an opensource tool written in PHP for administering MySQL and MariaDB over the web. Install phpMyAdmin on Debian 10 Buster Prerequisites phpMyAdmin requires a web server, PHP and a database in order to operate. To meet the requirements, this guide uses LAMP stack. To install...

Let us learn how to install phpMyAdmin with Nginx on Debian 10 Buster. phpMyAdmin is used to administer MySQL and MariaDB over the web. Install phpMyAdmin with Nginx on Debian 10 Buster Prerequisites Install LEMP Stack on Debian 10 Buster As a prerequisite of running phpMyAdmin with Nginx, you need to have installed and setup LEMP Stack on Debian 10 Buster. If you have...

Welcome to our guide on how to install Microsoft SQL server 2017 on Fedora 29/CentOS 7. Before you can follow through, ensure that your server meets the following minimum requirements; At least 2GB of RAM 64-bit CPU architecture At least 6GB of disk space At least 2x2GHZ CPU cores EXT4 or XFS filesystem Install Microsoft SQL Server 2017 on Fedora...

In this tutorial, we are going to learn how to install MySQL 8 on FreeBSD 12. MySQL 8 can be installed on FreeBSD 12 using Ports collection or using the MySQL generic Unix binaries. This guide focuses on using the FreeBSD 12 Ports collection. Install MySQL 8 on FreeBSD 12 To compile an application/port using Ports Collection, you should first install...

This guide will take you through how to install MariaDB 10.4 on CentOS 8 system. As of this writing, MariaDB 10.4 is the current stable (GA) series of MariaDB. You can read more about MariaDB 10.4 features. Install MariaDB 10.4 on CentOS 8 Install MariaDB 10.4 YUM Repository The default CentOS 8 AppStream repo contains MariadDB 10.3 (As of this writing). To install MariaDB...

This guide will quickly take you through how to install MariaDB 10.3 on CentOS 7. The current stable release of MariaDB is v10.3.15. Se how to install MariaDB 10.3 on Fedora 30 by following the link below; Install MariaDB 10.3 on Fedora 30 Install MariaDB 10.3 on CentOS 7 Update and upgrade your system packages. yum update yum upgrade Adding the MariaDB YUM repository The latest...

Welcome to our guide on how to install MariaDB 10 on Debian 10 Buster. As of this writing, MariaDB 10.4 is the latest stable release. Install MariaDB 10 on Debian 10 Buster In this guide, we are going to install MariaDB 10.4 on Debian Buster. However, the default Debian 10 Buster repositories provides MariaDB 10.3. apt policy mariadb-server mariadb-server: Installed: (none) ...

This guide will demonstrate how to install LAMP stack with MariaDB 10 on Debian 10 Buster. LAMP stack is a representation of web services attacks and it stands for; the Linux OS, Apache HTTP Server, MySQL/MariaDB relational database management system (RDBMS), and the PHP programming language. They can all be bundled together on a server for running web services. Install LAMP Stack with MariaDB 10 on Debian...

This guide describes how to enable MSSQL server and database level auditing. Database auditing basically involves capturing and  monitoring database activities. The server-level audit involves server operations, such as management changes and logon and logoff operations while database level auditing involves actions such as data manipulation languages (DML) and data definition language (DDL) operations. Enable MSSQL Server and Database Level...