Series: MySQL via Command Line 101: Basic Database Interaction

Generating frequent backups of databases is important to recover data and rerun it if any problems occur. Such problems include:

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.

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

Next Series:
MySQL via Command Line 102: Basic User Interaction

Preflight Check

• These instructions are intended for creating a MySQL database on Linux via the command line.
• I’ll be working from a Liquid Web Core Managed CentOS 7 VPS server, and I'll be logged in as root.

Create a MySQL Database

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

• These instructions are intended for setting the password for all MySQL users named root on Linux via the command line. However, they can also be followed to change the password for any MySQL user.
• I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.

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