Tag: Privileges
Grant Permissions to a MySQL User on Linux via Command Line
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.
Login to MySQL
First we'll log in to the MySQL server from the command line with the following command:
How To Add a User and Grant Root Privileges on Ubuntu 18.04
Adding a user and granting that user root privileges is one of the many tasks of a system admin. Once a user has been added and granted root privileges they’ll be able to login to your Ubuntu VPS and perform vital functions for the upkeep of the system. Afterward, they’ll be able to use sudo before commands to perform elevated tasks. In this quick tutorial, we’ll show you how to add a new user and grant root permissions.
How to Add a User and Grant Root Privileges on Ubuntu 16.04
Ubuntu 16.04 LTS provides you the ability to add a user for anyone who plans on accessing your server. Creating a user is a basic setup but an important and critical one for your server security. In this tutorial, we will create a user and grant administrative access, known as root, to your trusted user.
Remove Permissions for a MySQL User on Linux via Command Line
- 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
MySQL via Command Line 101: Basic Database Interaction
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.