MySQL On Linux Tutorial | Install | Grant And Revoke Privileges | Create Users | LOAD DATA

In this tutorial, you are going to learn how to Set up MySQL server on Linux. You’re also going to learn how to CREATE Users, CREATE ROLES, GRANT and REVOKE privileges to and from Users on the system.

You’re also going to learn how to upload data from files into a table using the LOAD DATA and INSERT command!

1:00 – Install Node js
1:43 – Install MySQL cli
2:23 – Download MySQL
5:15 – Configure that PATH for MySQL
7:24 – Login into MySQL
9:27 – Create Database
10:23 – Create Users
14:38 – Grant Pivileges
17:40 – Revoke Privileges
21:28 – Create Role
24:56 – Create Tables
28:57 – Load Data into Table using CSV
37:24 – INSERT into tables

[ad_2]

source