Change a Password for MySQL on Linux via Command Line

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

Pre-Flight 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 server, and I’ll be logged in as root.

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

Select a MySQL Database on Linux via Command Line

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

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

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 cp a file to another name, and cp it back if your change does not workout. With MySQL, it is not quite that simple, but it is by no means difficult.

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