Series: MySQL via Command Line 102: Basic User Interaction

Using MySQL Command Line to Create a User

Posted on August 28, 2020 by Justin Palmer | Updated: April 11, 2023

Category: Series | Tags: CentOS, CentOS 6, CLI, Command-line, Create, Database, Linux, MariaDB, MySQL, Select, User

Reading Time: 3 minutes

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

Continue reading →

Grant Permissions to a MySQL User on Linux via Command Line

Posted on May 29, 2020 by Justin Palmer | Updated: March 10, 2021

Category: Series | Tags: All, CLI, Command-line, Create, Database, delete, drop, Execute, grant option, Insert, Linux, MySQL, Permissions, Privileges, Select, Show Databases, Update, User

Reading Time: 2 minutes

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

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.

Grant Permissions to a MySQL User on Linux via Command Line

Login to MySQL

First we'll log in to the MySQL server from the command line with the following command:

Continue reading →

Remove a MySQL User on Linux via Command Line

Posted on March 28, 2014 by Justin Palmer | Updated: March 12, 2021

Category: Series | Tags: CLI, Command-line, Database, drop, Linux, MySQL, Select, User

Reading Time: 2 minutes

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

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.

How to Remove a MySQL User on Linux via Command Line

Login to MySQL

First we'll log in to the MySQL server from the command line with the following command:

Continue reading →

Remove Permissions for a MySQL User on Linux via Command Line

Posted on March 25, 2014 by Justin Palmer | Updated: March 5, 2021

Category: Series | Tags: All, CLI, Command-line, Create, Database, delete, drop, Execute, grant option, Insert, Linux, MySQL, Permissions, Privileges, revoke, Select, Show Databases, Update, User

Reading Time: 2 minutes

MySQL via Command Line 102: Basic User Interaction

Using MySQL Command Line to Create a User
Grant Permissions to a MySQL User on Linux via Command Line
Remove Permissions for a MySQL User on Linux via Command Line
Remove a MySQL User on Linux via Command Line

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

How to Remove Permissions for a MySQL user on Linux via Command Line

Continue reading →

Categories

Have Some Questions?

Our Sales and Support teams are available 24 hours by phone or e-mail to assist.

1.800.580.4985

1.517.322.0434