Summary
Keywords
Full Transcript
Learn how to grant SELECT, INSERT, and more privileges to users in MySQL using SQL GRANT command. Welcome to Lecture 20 of the MySQL Full Course in Pashto, taught by Malik Ahad on the IT HUB channel. In this lecture, we focus on the GRANT command in SQL — a powerful Data Control Language (DCL) feature used to assign user permissions in MySQL databases. Whether you're managing a school database or working with live SQL environments, this video teaches you how to safely grant access to users using practical examples — all in Pashto language. 🔍 What You’ll Learn in This Video: 1. Introduction to Data Control Language (DCL). 2. Purpose and use of the GRANT command. 3. GRANT syntax explained step-by-step. 4. Giving permissions like SELECT, INSERT using SQL. 5. Real-world project example: SchoolManagementSystem database. 6. Granting access to specific tables (e.g., Students table). 7. Understanding 'username'@'host' structure. 8. Best practices for user access control in MySQL. 9. Live demonstration using SQL query and MySQL interface. 10. Why permission management is important in database security. 🔔 Subscribe to IT HUB to continue this free MySQL Course in Pashto. 🎓 Also available: CCNA, Java, Cybersecurity, MS Office, and more – in Pashto! 📱 Follow Us: 👍 Facebook Page Link: https://www.facebook.com/ithubfbpage 📱 What'sApp Group Link: https://chat.whatsapp.com/IFilHCvlUaADU7PIEcLSUE 📑 Download Notes (Telegram): https://t.me/ithubpashto Must-Watch Videos: ►https://youtu.be/nWPTBh2zpCM?si=OhiEZFBhLzS1F3xo ►https://youtu.be/aysaUL8Ywbc?si=Lplenss-h9PL1VBH MySQL Complete Course: ►https://www.youtube.com/watch?v=nN8s583uXGg&list=PLwOLLyI1hgPEyGhDir510BLR8pepc_F4R&pp=0gcJCWMEOCosWNin Java Complete Course: ►https://www.youtube.com/watch?v=wF4-lAOctps&list=PLwOLLyI1hgPFwZRHuLVatCaNrQ_creQkQ CCNA Complete Course ►https://www.youtube.com/watch?v=Bxqj8RFmXg0&list=PLwOLLyI1hgPHwTL44iFdnZaiTt8ZwEE6K Photoshop Pashto Complete Course: ►https://www.youtube.com/watch?v=V8G3sH6lMhk&list=PLwOLLyI1hgPEciz0JHVhJvu8-vpbGVTCh Let’s unlock the world of tech together—subscribe now! 🚀
