Category: Series

The Series category provides accurate and in-depth information regarding a variety of topics and subjects. Because these subjects tend to be larger and take longer to read and study, we breaking the info into more manageable chunks to ensure it is easily digestible by everyone.

Reading Time: 2 minutes

When working with MySQL in the command line, it is important to ensure proper selection of the database you wish to work with. Administering a server has its challenges without unnecessary errors due to an incorrect database selection. This article shows you how to select a MySQL database in Linux via the command line.

Continue reading →

Create a MySQL Database on Linux via Command Line

Posted on by Ronald Caldwell | Updated:
Reading Time: 2 minutes

While the are many ways to create databases, system administrators benefit from knowing how to create a MySQL database in Linux via the command line. Knowing more than one way to accomplish a task provides flexibility in case the usual way you perform it is not an option. Use this tutorial to create a MySQL database via the command line.

Continue reading →
Reading Time: 2 minutes

Data security is essential to developers, business owners, and system administrators. A vital element of securing data is password management. This guide will teach you how to change a MySQL password in Linux using the command line.

Continue reading →
Reading Time: 6 minutes
A Mysql Indexing Logo

Throughout this tutorial, we will cover some of the fundamentals of indexing. As part of the MySQL series, we will introduce capabilities of MySQL indexing and the role it plays in optimizing database performance. Liquid Web recommends consulting with a DBA before making any changes to your production level application.

Continue reading →
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 →
Reading Time: 4 minutes

Before we get into the details of Apache tuning, we need to understand what happens when a VPS server or Dedicated server goes unresponsive due to a poorly optimized configuration.

Continue reading →
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.
Grant Permissions to a MySQL User on Linux via Command Line

Login to MySQL

First we'll log in to the MySQL server from the command line with the following command:

Continue reading →
Reading Time: 3 minutes

In this article, we will be reviewing how to connect to your WordPress Optimized Template using SFTP as the connection medium.

Continue reading →
← Older posts
Have Some Questions?

Our Sales and Support teams are available 24 hours by phone or e-mail to assist.

1.800.580.4985
1.517.322.0434