Series: MySQL via Command Line 101: Basic Database Interaction
How to Backup and Restore a MySQL Database
Posted on by Mohammed Noufal | Updated:
Reading Time: 7 minutes
Next in Series:
MySQL via Command Line 102: Basic User Interaction
MySQL via Command Line 102: Basic User Interaction
Generating frequent backups of databases is important to recover data and rerun it if any problems occur. Such problems include:
Select a MySQL Database on Linux via Command Line
Posted on by Justin Palmer | Updated:
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.

First we'll login to the MySQL server from the command line with the following command:
Reading Time: 2 minutes
Continue reading →Create a MySQL Database on Linux via Command Line
Posted on by Justin Palmer | Updated:
Reading Time: 2 minutes
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:
Change a Password for MySQL on Linux via Command Line
Posted on by Justin Palmer | Updated:
Reading Time: < 1 minute
Next in Series:
MySQL via Command Line 102: Basic User Interaction
MySQL via Command Line 102: Basic User Interaction
Preflight Check
- 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:
Categories
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