How to Create a MySQL User via Command Line

Reading Time: 2 minutes

Previous Series:
MySQL via Command Line 101: Basic Database Interaction

In this article, we will be discussing how to create a MySQL user on Linux via the command line. We will be working on a Liquid Web core-managed server running CentOS version 6.5 as the root user. The commands used should work on later versions of MySQL on CentOS as well.

Preflight Check

  • Log in as the root user.
  • Have access to a terminal.
  • Basic knowledge of the command line.
Continue reading “How to Create a MySQL User via Command Line”

Grant Permissions to a MySQL User on Linux via Command Line

Reading Time: 2 minutes

Preflight Check

  • These instructions are intended for granting a MySQL user permissions on Linux via the command line
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
Continue reading “Grant Permissions to a MySQL User on Linux via Command Line”

Creating and Deleting a PostgreSQL Database on Ubuntu 16.04

Reading Time: 2 minutes

PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems.

Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language.  In this tutorial, we will be demonstrating some essentials like creating, listing and deleting a database.

Continue reading “Creating and Deleting a PostgreSQL Database on Ubuntu 16.04”

How to Set Up A Firewall Using Iptables on Ubuntu 16.04

Reading Time: 5 minutesThis guide will walk you through the steps for setting up a firewall using iptables in an Ubuntu VPS server. We’ll show you some common commands for manipulating the firewall, and teach you how to create your own rules.

Continue reading “How to Set Up A Firewall Using Iptables on Ubuntu 16.04”

How to Create and Clone a Repo in GitHub on Ubuntu 18.04

Reading Time: 3 minutes

GitHub is a free repository hosting service, used as version control for web developers to download and push their code from their servers to other users.  In our previous article we’ve instructed on how to add Git to your Ubuntu VPS server. We’ll continue on and show you how to add and clone a repo from GitHub to your server.

Continue reading “How to Create and Clone a Repo in GitHub on Ubuntu 18.04”

What is Kubernetes RBAC Authorization

Reading Time: 4 minutes

What is RBAC?

Kubernetes Role-Based Access Control or the (RBAC) system describes how we define different permission levels of unique, validated users or groups in a cluster. It uses granular permission sets defined within a .yaml file to allow access to specific resources and operations.

Starting with Kubernetes 1.6, RBAC is enabled by default and users start with no permissions, and as such, permissions must be explicitly granted by an admin to a specific service or resource. These policies are crucial for effectively securing your cluster. They permit us to specify what types of actions are allowed, depending on the user’s role and their function within the organization.

Continue reading “What is Kubernetes RBAC Authorization”

A Beginner’s Guide to Managed WordPress

Reading Time: 7 minutesThank you for choosing Managed WordPress at Liquid Web! We hope this guide will help you get started in making the most of your experience with the Managed WordPress Portal. There are some great features in the portal, and we’ve worked hard to make sure site maintenance is a cinch. Continue reading “A Beginner’s Guide to Managed WordPress”