Change a Password for MySQL on Linux via Command Line

Posted on by Justin Palmer | Updated:
Category: Series, Technical Support | Tags: , , , , , ,
Reading Time: < 1 minute

 

Next in Series:
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.

Continue reading “Change a Password for MySQL on Linux via Command Line” →

Create a MySQL Database on Linux via Command Line

Posted on by Justin Palmer | Updated:
Category: Series | Tags: , , , ,
Reading Time: 2 minutes
Next Series:
MySQL via Command Line 102: Basic User Interaction

Preflight Check

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

Select a MySQL Database on Linux via Command Line

Posted on by Justin Palmer
Category: Series, Technical Support | Tags: , , , , , ,

Reading Time: 2 minutes

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

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” →

3 Tips For Working With a MySQL Database!

Posted on by J. Mays | Updated:
Category: Series, Technical Support, Tutorials | Tags: , , , , , ,

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 “3 Tips For Working With a MySQL Database!” →

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

Posted on by Alex Gorzen | Updated:
Category: Series, WHM + cPanel | Tags: , , , , ,

Reading Time: 2 minutes

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

While automated backups are important, sometimes you just want to take a MySQL dump of the database prior to making a change to your site. When modifying files in Linux, you can simply copy a file to another name in order 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” →