Series: MySQL via Command Line 101: Basic Database Interaction

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.

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

While automated backups are important, sometimes you just want to take a MySQL dump of the database before making a change to your site. When modifying files in Linux, you can simply copy a file to another name to make a new copy. In this tutorial, we will show you how to create a backup of your database (or multiple databases) and also how to restore a backup from either command line or cPanel.

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.