Tag: All

Grant Permissions to a MySQL User on Linux via Command Line

Posted on May 29, 2020 by Justin Palmer | Updated: June 4, 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 Permissions for a MySQL User on Linux via Command Line

Posted on March 25, 2014 by Justin Palmer | Updated: August 24, 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

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

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

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.

Login to MySQL

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

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