How to Create a MySQL User via Command Line

Reading Time: 2 minutes

Previous Series:
MySQL via Command Line 101: Basic Database Interaction

In this article, we will be discussing how to create a MySQL user on Linux via the command line. We will be working on a Liquid Web core-managed server running CentOS version 6.5 as the root user. The commands used should work on later versions of MySQL on CentOS as well.

Preflight Check

  • Log in as the root user.
  • Have access to a terminal.
  • Basic knowledge of the command line.
Continue reading “How to Create a MySQL User via Command Line”

Grant Permissions to a MySQL User on Linux via Command Line

Reading Time: 2 minutes

Preflight Check

  • These instructions are intended for granting a MySQL user permissions 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 “Grant Permissions to a MySQL User on Linux via Command Line”

Remove Permissions for a MySQL User on Linux via Command Line

Reading Time: 2 minutes 

 


 

Preflight Check
  • These instructions are intended for revoking a MySQL user permissions 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 “Remove Permissions for a MySQL User on Linux via Command Line”

Remove a MySQL User on Linux via Command Line

Reading Time: < 1 minute 

 

Preflight Check
  • These instructions are intended for removing a MySQL user 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 “Remove a MySQL User on Linux via Command Line”