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
⚡ झट से 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
इस 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.