Tag: grant option
Grant Permissions to a MySQL User on Linux via Command Line
Posted on by Justin Palmer | Updated:
Reading Time: 2 minutes
Previous Series:
MySQL via Command Line 101: Basic Database Interaction
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](https://wwwdev.lwinternal.com/wp-content/uploads/2020/05/grant.perms_.mysqluser.052620.jpg)
Login to MySQL
First we'll log in to the MySQL server from the command line with the following command:
How to Work With PostgreSQL Databases
Posted on by Andrej Walilko
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
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
II. How to Remove (Delete) a User on Fedora 23
Remove Permissions for a MySQL User on Linux via Command Line
Posted on by Justin Palmer | Updated:
Reading Time: 2 minutes
- Create a MySQL User on Linux via Command Line
- 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
MySQL via Command Line 101: Basic Database Interaction
![How to Remove Permissions for a MySQL user on Linux via Command Line](https://wwwdev.lwinternal.com/wp-content/uploads/2020/04/remove.perms_.mysql_.cli_.04120.jpg)
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