Administration & Security
User Management
CREATE USER, GRANT, REVOKE
💡 User, management, EK, "OFFICE, KEYCARD, SYSTEM" jaisa, hai — HAR, employee, (USER) ko, EK, keycard, MILТА, hai, JO, DECIDE, karta hai, WOH, KAUN, se, "ROOMS" (databases/tables) mein, JAA, sakta, hai.
CREATE USER, EK, naya, MySQL, user, banaता hai (username, aur, password, ke, saath). GRANT, statement, se, USER, ko, SPECIFIC, PERMISSIONS, (SELECT, INSERT, UPDATE, ALL, PRIVILEGES) DI, jaati, HAIN.
REVOKE, statement, se, PREVIOUSLY, granted, permissions, ko, REMOVE, kiya, jaata hai. "Principle, of, least, privilege" FOLLOW, karna, CHAHIYE — sirf, ZAROORI, permissions, dena.
CREATE USER 'app_user'@'localhost' IDENTIFIED BY 'securePassword';
GRANT SELECT, INSERT, UPDATE ON myapp.* TO 'app_user'@'localhost';
FLUSH PRIVILEGES;
-- Permissions remove karna:
REVOKE UPDATE ON myapp.* FROM 'app_user'@'localhost';👤
User, management, EK, "OFFICE, KEYCARD, SYSTEM" jaisa, hai — HAR, employee, (USER) ko, EK, keycard, MILТА, hai, JO, DECIDE, karta hai, WOH, KAUN, se, "ROOMS" (databases/tables) mein, JAA, sakta, hai.
1 / 2
⚡ Quick Recap
- CREATE USER = naya, user, banaта, hai. GRANT = permissions, deta, hai
- REVOKE = permissions, remove, karta, hai
- "Principle of least privilege" — sirf, zaroori, permissions, dena, CHAHIYE
On this page (2 subtopics)
MySQL, users, EK, host, ke, saath, SPECIFY, kiye, jaate, hain — 'user'@'localhost', 'user'@'%' se, DIFFERENT, hai (jahaan, % ka, matlab, hai, KISI, BHI, host, se, connect, ho, sakta hai).
CREATE USER 'admin'@'192.168.1.%' IDENTIFIED BY 'password';
-- Sirf, specific, IP, range, se, hi, connect, ho, sakta, haiSHOW GRANTS FOR 'user'@'host', EK, user, ki, SAARI, PERMISSIONS, dikhaता hai — security, audits, ke, liye, USEFUL, hai, ki, KAUN, KYA, ACCESS, kar, sakta hai.
Tip: Regular, security, audits, mein, SHOW GRANTS, se, saare, users, check, karna, chahiye — over-privileged, accounts, IDENTIFY, karne, ke, liye.