Recognition

Posts

132 Posts
  • 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

    Understanding SQL Constraints

    Relational database management systems allow you to control what data gets added to a table with constraints. A constraint is a special rule that applies to one or more columns — or to an entire table — that restricts...
    By Mark Drake Databases SQL Conceptual
  • 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 series

    How To Use SQL

    Series Description Structured Query Language (https://en.wikipedia.org/wiki/SQL) — commonly known as SQL — is a language used to define, control, manipulate, and query data held in a relational database. SQL has been ...
    By Mark Drake Databases Conceptual 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
  • Published Tutorial

    How To Install Webmin on Ubuntu 20.04

    Webmin is a web-based control panel for any Linux machine which lets you manage your server through a modern web-based interface. With Webmin, you can change settings for common packages on the fly, including web serv...
    By Theo B, Kathleen Juell, Mark Drake Apache Control Panels Applications Let's Encrypt Ubuntu Ubuntu 20.04
  • Published Tutorial

    How To Migrate Redis Data to a DigitalOcean Managed Database

    Redis provides a number of methods one can use to migrate data from one instance to another, like replication and snapshotting. However, migrations can get complicated when you're moving data to a Redis instance manag...
    By Mark Drake Redis Databases Ubuntu 18.04