How to grant and revoke privileges in MySQL on macOS?

Опубликовано: 14 Июль 2022
на канале: LittleTek Pro
648
11

We'll learn How to create, delete user and grant, revoke privileges in MySQL from terminal & workbench on macOS?
How do I revoke a user privilege in MySQL?
How do I create a new user and grant privileges in MySQL?
Which command grants or removes other users privileges in MySQL?
How do I grant user privileges to user in MySQL?
How do I GRANT and REVOKE privileges in SQL?
How do I REVOKE user privileges?
What is REVOKE command in SQL?
What is GRANT and revoke in database?
How the GRANT and revoke commands can be used for access control?
What is GRANT option in MySQL?
Is REVOKE available in MySQL?
How do I GRANT privileges in SQL?
What is GRANT REVOKE privileges?
What is granting and revoking privileges?
How do I provide Grant permissions in SQL server?
How do you write a grant command in SQL?
//////////////////////////////////////////////////////////////////////////////////
𝌞 TABLE of CONTENT
0:00 Introduction
00:48 Create an User from the terminal
02:00 Grant and revoke privileges from the terminal
08:10 Delete user from the terminal
08:40 Create and Grant privileges to user from MySQL Workbench
15:10 Revoke privileges from MySQL Workbench
17:20 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  

👀 DO NOT FORGET TO VISIT:
Facebook :  / littletekpro  
Instagram:   / pramod.prad  
Twitter :   / pramodp68379475  

#mysqlCreateUser #grantUserPrivileges #revokePrivileges #deleteUser #adminUser #rootUser