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”

Create a MySQL User on Linux via Command Line

Reading Time: < 1 minute

Pre-Flight Check

  • These instructions are intended for creating a MySQL user 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 “Create a MySQL User on Linux via Command Line”

How to Add a User and Grant Root Privileges on Ubuntu 16.04

Reading Time: 2 minutes

Ubuntu 16.04 LTS provides you the ability to add a user for anyone who plans on accessing your server.  Creating a user is a basic setup but an important and critical one for your server security. In this tutorial, we will create a user and grant administrative access, known as root, to your trusted user.

Continue reading “How to Add a User and Grant Root Privileges on Ubuntu 16.04”

How To Change the SNMP Port on CentOS

Reading Time: 2 minutes

Introduction

SNMP, or Simple Network Management Protocol, is widely used to communicate with and monitor network devices, servers, and more, all via IP. In the previous article, we installed an SNMP agent on a CentOS 6.5 server. This agent allows for the collection of data from our server and makes the information available to a remote SNMP manager. To add a little security, we’ll now change the port that SNMP listens on.

Continue reading “How To Change the SNMP Port on CentOS”

How to Install and Configure Nano on CentOS 8

Reading Time: 10 minutes

Introduction

Most Linux distributions ship with a command-line based text editor, usually Vi/Vim or Nano. While both are excellent choices, Vim has a steeper learning curve and can be confusing for beginners. Nano, on the other hand, will feel much more familiar to anyone who has used notepad or other simple text editors in a desktop or other graphical user interface. This is not to say that Nano is not as feature rich as Vim; it is simply more accessible.

Continue reading “How to Install and Configure Nano on CentOS 8”

How to List Compiled PHP Modules from Command Line

Reading Time: 2 minutes
Pre-Flight Check
  • These instructions are intended specifically for listing the existing compiled PHP modules from the command line.
  • Your server environment may be different, but we will go over several options that you might run into. We’ll be using an Ubuntu Server with only a single PHP version on it, and two CentOS 7 servers, one with cPanel and one with InterWorx.
Continue reading “How to List Compiled PHP Modules from Command Line”

Select a MySQL Database on Linux via Command Line

Reading Time: 2 minutes

Pre-Flight Check

  • These instructions are intended for selecting a MySQL database 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 “Select a MySQL Database on Linux via Command Line”

Show (List) MySQL Databases on Linux via Command Line

Reading Time: < 1 minute

Pre-Flight Check

  • These instructions are intended for showing (listing) all MySQL databases via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.

Continue reading “Show (List) MySQL Databases on Linux via Command Line”