Grant Permissions to a MySQL User on Linux via Command Line

Posted on May 29, 2020 by Justin Palmer | Updated: June 9, 2020
Category: Series, Tutorials | 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.

Continue reading →

Related Articles:

How to Backup, Delete and Restore a PostgreSQL Database in CentOS 7 or Ubuntu 16

Posted on February 21, 2019 by Andrej Walilko | Updated: June 5, 2020
Category: Tutorials | Tags: Backups, Database, delete, grant option, PostgreSQL, Restore, Users

Reading Time: 5 minutes

Table of Contents

Listing databases
Dump a database
Dumping all databases
Dump Grants
Delete or Drop a Database
Delete a Grant
Restore a Database
Restore Grant
Continue reading “How to Backup, Delete and Restore a PostgreSQL Database in CentOS 7 or Ubuntu 16” →

Related Articles:

How To Add a User and Grant Root Privileges on Fedora 23

Posted on January 25, 2016 by dpepper | Updated: January 29, 2019
Category: Tutorials | Tags: Adduser, Fedora 23, grant option

Reading Time: < 1 minute

Note:

Please note that this article is considered legacy documentation because this OS has reached its end-of-life support.

Users via Command Line 101: Basic User Interaction

I. How to Add a User and Grant Root Privileges on Fedora 23
II. How to Remove (Delete) a User on Fedora 23

Continue reading “How To Add a User and Grant Root Privileges on Fedora 23” →

Related Articles:

Remove Permissions for a MySQL User on Linux via Command Line

Posted on March 25, 2014 by Justin Palmer | Updated: April 1, 2020
Category: Series, Technical Support, Tutorials | 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

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

Related Articles: