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

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

Continue reading →
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.
select a database via the command line

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

Continue reading →
Reading Time: 2 minutes

Preflight Check

Create a MySQL Database

Create a MySQL Database on Linux via Command Line

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

Continue reading →
Reading Time: < 1 minute
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.
Change a Password for MySQL on Linux via Command Line


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

Continue reading →
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