Change a Password for MySQL on Linux via Command Line

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.
Continue reading “Change a Password for MySQL on Linux via Command Line”

Create a MySQL Database on Linux via Command Line

Reading Time: 2 minutes

Preflight Check

Continue reading “Create a MySQL Database on Linux via Command Line”

Select a MySQL Database on Linux via Command Line

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.
Continue reading “Select a MySQL Database on Linux via Command Line”

How to Delete A Database In MySQL/MariaDB

Reading Time: 2 minutes

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

Pre-Flight Check

  • These instructions are intended for deleting a MySQL database on Linux via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
Continue reading “How to Delete A Database In MySQL/MariaDB”

How to Back Up And Restore MySQL Databases From The Command Line

Reading Time: 3 minutes

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.

Continue reading “How to Back Up And Restore MySQL Databases From The Command Line”