Free tutorials in Hindi & English Clean code examples with output Mobile friendly learning
MySQL + SQL · Lesson 106

MySQL Users and Privileges

Managing Users

MySQL lets the DBA create users and give each one only the privileges they need — a core security practice.

Create User & Grant

CREATE USER 'teacher'@'localhost' IDENTIFIED BY 'pass123';
GRANT SELECT, UPDATE ON school.* TO 'teacher'@'localhost';
FLUSH PRIVILEGES;

SHOW GRANTS FOR 'teacher'@'localhost';

Principle of Least Privilege

Give each user only the minimum access they need. A fee clerk should not be able to DROP tables.

Summary

  • CREATE USER makes accounts; GRANT assigns privileges.
  • Follow least privilege — minimum access per user.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

\n

💻 Live Code Editor

Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.
Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.

💻 Live Code Editor

Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें. Agar load na ho to naye tab mein kholें.