MySQL- Create, assign and revoke roles.
This video is for step by step tutorial to create users, assign privileges & roles and drop user & roles . This video would give answers to following questions as well
How do I give a user a role in MySQL?
How are permissions implement in MySQL?
What are the roles in MySQL?
How do I create a role in MySQL?
How do you set a role in a database?
How do I change MySQL privileges?
How do I get users in MySQL?
How do you create a role?
How do you create a new role in SQL?
How do you add user roles in a database?
How do I grant permission to user in SQL?
How do I change user privileges?
How do I setup a user access?
How do you restrict a database?
How do I restrict Access database?
How do I split an Access database for multiple users?
//////////////////////////////****************************//////////////////////////////
𝌞 TABLE of CONTENT
0:00 Introduction
02:20 Create roles in MySQL
03:10 Grant privileges to roles from the terminal
05:21 Create MySQL users from the terminal.
07:32 Assigning roles to the users.
09:55 Establish connection for new user to MySQL from the workbench.
10:53 Access database based on user's privileges from the Workbench.
13:45 Activate Role
14:57 Drop users and Roles.
17:30 Summary and Thank you!
///////////////////////////////////////////////////////////////////////////////////////////////
⚙️ How to install MySQL server, here is the link: • How to install MySQL on macOS and inv...
⚙️ How to install MySQL Workbench and import sample Database : • How to download and install MySQL Wor...
📕 Workbench Keyboard shortcuts guideline:https://drive.google.com/file/d/13WEo...
📒 Sample Database for practice, here is the link to download :https://drive.google.com/file/d/1o6cE...
❤️ For more video like this one, just subscribe to Littletek Pro Channel : / @littletekpro
🧿 NOT FORGET TO VISIT:
Facebook : / littletekpro
Instagram: / pramod.prad
Twitter : / pramodp68379475
#mysqlcreateUsers #mysql #mysqlroles #mysqluserprivileges #mysqldropuser #mysqldroproles
