Recognition

Posts

117 Posts
  • Published Tutorial

    How To Install and Secure phpMyAdmin on Ubuntu 20.04

    phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 20.04 server.
    By Mark Drake Apache Applications PHP Ubuntu Ubuntu 20.04
  • Published Tutorial

    How To Secure Apache with Let's Encrypt on Debian 10

    Let's Encrypt is a Certificate Authority (CA) that provides an easy way to obtain and install free TLS/SSL certificates, thereby enabling encrypted HTTPS on web servers. In this tutorial, you will use Certbot to obtai...
    By Kathleen Juell, Mark Drake, Erika Heidi Let's Encrypt Apache Security Debian 10
  • Published Tutorial in Series: How To Use SQL

    How To Use Joins in SQL

    Many database designs separate information into different tables based on how certain data points relate to one another. Even in cases like this, it's likely that there will be times when someone will want to retrieve...
    By Mark Drake Databases SQL
  • Published Tutorial in Series: How To Use SQL

    How To Update Data in SQL

    When working with a database, there may be times when you need to change data that's already been inserted into it; you may need to correct a misspelled entry, or perhaps you have information to add to an incomplete r...
    By Mark Drake SQL Databases
  • Published Tutorial

    How To Install phpMyAdmin From Source on Debian 10

    phpMyAdmin is an application that allows users to interact with MySQL (or MariaDB) databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on a Debian 10 server.
    By Mark Drake Applications PHP Apache MariaDB Debian 10
  • Published Tutorial

    How To Install MongoDB from the Default APT Repositories on Ubuntu 20.04

    MongoDB is a free and open-source NoSQL document database used commonly in modern web applications. By following this tutorial you'll install MongoDB on an Ubuntu 20.04 server using the default APT repositories. You'l...
    By Mateusz Papiernik, Mark Drake MongoDB Ubuntu Ubuntu 20.04 Databases NoSQL
  • Published Tutorial

    How To Configure Remote Access for MongoDB on Ubuntu 18.04

    This tutorial walks you through configuring a MongoDB installation to securely allow access from a trusted remote computer. This will involve updating your firewall rules to provide the remote server access to MongoDB...
    By Mark Drake MongoDB Firewall Security Databases NoSQL Ubuntu Ubuntu 18.04
  • Published Tutorial

    How To Secure MongoDB on Ubuntu 18.04

    MongoDB doesn't have authentication enabled by default, meaning that any user with access to the server where the database is installed can add and delete data without restriction. In order to secure this vulnerabilit...
    By Mark Drake MongoDB Databases Security NoSQL Ubuntu Ubuntu 18.04
  • Published Tutorial

    How To Install MongoDB on Ubuntu 18.04

    MongoDB is an open-source document database used commonly in modern web applications. It is classified as a NoSQL database because it does not rely on a traditional table-based relational database structure. Instead,...
    By Mark Drake MongoDB NoSQL Databases Ubuntu Ubuntu 18.04
  • Published Tutorial

    How To Set Up an OpenVPN Server on Debian 10

    OpenVPN is a full-featured, open-source Secure Socket Layer (SSL) VPN solution that accommodates a wide range of configurations. In this tutorial, you will set up an OpenVPN server on a Debian 10 server and then confi...
    By Justin Ellingwood, Mark Drake VPN Security Debian Debian 10
  • Published Tutorial

    How To Secure MongoDB on CentOS 8

    MongoDB doesn't have authentication enabled by default, meaning that any user with access to the server where the database is installed can add and delete data without restriction. In order to secure this vulnerabilit...
    By Mark Drake MongoDB Databases NoSQL Security CentOS CentOS 8
  • Published Tutorial

    How To Configure Remote Access for MongoDB on CentOS 8

    This tutorial walks you through configuring a MongoDB installation to securely allow access from a trusted remote computer. This will involve updating your firewall rules to provide the remote server access to MongoDB...
    By Mark Drake MongoDB Databases NoSQL Firewall Networking Security CentOS CentOS 8
  • Published Tutorial

    How To Install MongoDB on CentOS 8

    MongoDB is an open-source document database used commonly in modern web applications. It is classified as a NoSQL database because it does not rely on a traditional table-based relational database structure. Instead,...
    By Mark Drake CentOS 8 CentOS MongoDB Databases NoSQL
  • Published Tutorial

    How To Install and Secure Redis on CentOS 8

    This tutorial provides instructions for installing Redis on a CentOS 8 server and using its built-in security features, in coordination with some other security configurations, to keep it from being accessed by unauth...
    By Mark Drake Redis NoSQL Databases Firewall CentOS 8 CentOS
  • Published Tutorial in Series: How To Use SQL

    How To Delete Data in SQL

    As the name implies, DELETE operations irreversibly delete one or more rows of data from a database table. Being such a fundamental aspect of data management, it's important for SQL users to understand how the DELETE ...
    By Mark Drake Databases SQL
  • Published Tutorial in Series: How To Use SQL

    How To Use Constraints in SQL

    When designing an SQL database, there may be cases where you want to impose restrictions on what data can be added to certain columns in a table. SQL makes this possible through the use of constraints. After applying ...
    By Mark Drake SQL Databases
  • Published Tutorial in Series: How To Use SQL

    How To Insert Data in SQL

    SQL provides a great deal of flexibility in terms of how it allows you to insert data into tables. You can specify individual rows of data with the VALUES keyword, copy entire sets of data from existing tables with SE...
    By Mark Drake Databases SQL
  • Published Tutorial in Series: How To Use SQL

    How To Use Wildcards in SQL

    Like many computer languages, SQL allows the use of various wildcard characters. Wildcards are special placeholder characters that can represent one or more other characters or values. This is a convenient feature in ...
    By Mark Drake Databases SQL
  • Published Tutorial in Series: How To Use SQL

    How To Create and Manage Tables in SQL

    Tables are the primary organizational structure in SQL databases. They consist of any number of columns, which reflect individual attributes of each row, or record, in the table. Being such a fundamental aspect of dat...
    By Mark Drake Databases SQL
  • Published Tutorial

    How To Install and Secure Redis on CentOS 7

    This tutorial provides instructions for installing Redis on a CentOS 7 server and using its built-in security features, in coordination with some other security configurations, to keep it from being accessed by unauth...
    By Mark Drake Redis Security Firewall