Change a Password for MySQL on Linux via Command Line

Reading Time: 1 minute
Pre-Flight 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

Pre-Flight 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”

Delete a MySQL Database on Linux via Command Line

Reading Time: 1 minute

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 “Delete a MySQL Database on Linux via Command Line”

How to Back Up MySQL Databases From The Command Line

Reading Time: 2 minutes

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

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