MySQL Tutorial Part - 5 | Data Control Language (DCL) | Grant, Revoke and Create User |

USER MANAGEMENT / DATABASE administration :
#GRANT - access
#REVOKE - removing the access
1. GRANT : providing privileges to the user.
2. REVOKE : taking back the privileges from the user.
( USER MANAGEMENT )
CREATING A USER :
CREATE USER 'username'@'host_name' identifed by 'password';
viewing the privileges for a user :
SHOW GRANTS for 'username'@'host_name' ;
viewing privileges for current user :
SHOW GRANTS ;
granting privileges :
GRANT 'privilege' ON 'db_name'.'tbname' TO 'username'@'host_name';
granting all privileges :
#GRANT ALL PRIVILEGES ON . TO 'stchr'@'localhost' WITH GRANT OPTION ;
delete a user :
DROP USER 'username'@'localhost';
change the password :
ALTER USER 'username'@'localhost' identified by 'new_password' ;
change the username : ( get into mysql db first)
UPDATE USER SET user = 'new_username' WHERE user = 'old_username';
MySQL Tutorial in Tamil (1) - Types of Data - Part 1
• MySQL Tutorial in Tami...
MySQL Tutorial - PART 2 - Data Definition Language (DDL) - Types of SQL Statements - MySQL
• MySQL Tutorial - PART ...
MySQL Tutorial Part - 3 | Data Manipulation Language (DML) | How to Insert, update and Delete values
• MySQL Tutorial Part - ...
MySQL Tutorial - Part - 4 | Transaction control language (TCL) | Savepoint, Rollback and Commit
• MySQL Tutorial - Part ...
MySQL Tutorial - Part-6 | Not null, Unique, Primary key, Check, Default & Auto_increment
• MySQL Tutorial - Part-...

[@Shobiga_V]

Thank you so much bro. I was searching for user creation for long time. It's easy to understand too. Thank you so much 🙏

[@PrasanthTamizhan]

Most welcome 😊

[@Ammu_abi]

Thank you sir

[@trendingspot3956]

Thank you sir❤

[@Ajeshkarthi]

Vera level

[@PrasanthTamizhan]

Thanks