MySQL Performance: Identifying Long Queries

Reading Time: 6 minutes

Every MySQL backed application can benefit from a finely tuned database server. The Liquid Web Heroic Support team has encountered numerous situations over the years when some minor adjustments have made a world of difference in website and application performance. In this series of articles, we have outlined some of the more common recommendations that have had the largest impact on performance.

Continue reading “MySQL Performance: Identifying Long Queries”

What is the Difference Between Git and GitHub?

Reading Time: 4 minutes

What is Git?

gitlogo

Git is a distributed version control system (or VCS), typically used to track files changes. It was developed in 2005 by Linus Torvalds, the creator of the Linux kernel. Git’s primary use is to keep track of changes within source code during the software development process. Source Code Management or SCM was the primary reason for its creation.

Continue reading “What is the Difference Between Git and GitHub?”

Create a MySQL User on Linux 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 use MySQL to create a new 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 also work on later versions of MySQL on CentOS as well.

MySQL is a relational database management application primarily used on Linux and is a component of the LAMP stack (Linux, Apache, MySQL, and PHP).

Preflight Check

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

Install Oracle Java 8 on Ubuntu 18.04

Reading Time: 3 minutes

Java is a programming language used to build Android apps and real life web applications like Gmail and Google Docs. This ubiquitous language can be installed onto an Ubuntu server and its what we’ll be teaching in this tutorial today.

Continue reading “Install Oracle Java 8 on Ubuntu 18.04”

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”

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”