How to provide full permissions to user in MySQL Database
To provide full permissions on a Database to user in MySQL Server, you will be using below syntax.
Syntax:
WITH GRANT OPTION, user will be able to provide permissions to other users on the database. If you don't want that then remove the "With GRANT OPTION" from above statement.
Example:
Syntax:
MySQL > GRANT ALL ON DatabaseName.* TO 'UserName'@'Host' WITH GRANT OPTION;
Example:
Let's create user TB and provide full permissions on Database name "TechBrothers" , We also want the TB user to have permissions to GRANT permissions on "TechBrothers" databases to other users.
MySQL > Create User 'TB'@'localhost' Identified by "Password123";
MySQL > GRANT ALL ON TechBrothers.* TO 'TB'@'localhost' With GRANT OPTION;
It seems that the internet is very much interested in creating a fiction-based story like a Slender Man and other repeated ghost stories. Among all those false stories Teresa fidalgo ghost is one of them that gets hyped on the internet in a different way. I recommend this article for detailed information.
ReplyDeleteAivivu chuyên vé máy bay, tham khảo
ReplyDeletevé máy bay đi Mỹ bao nhiêu
vé máy bay từ mỹ về việt nam bao nhiêu
lịch bay từ canada về việt nam
bay từ nhật bản về việt nam
mua vé máy bay từ hàn quốc về việt nam
Vé máy bay từ Đài Loan về Việt Nam
khách sạn cách ly tại hà nội
ve may bay chuyen gia nuoc ngoai sang Viet Nam
Amazing article. Thanks for sharing with us.
ReplyDeletevisit our website for Dutch hormone Test
you are providing a Technical knowledge for whom who need this. Thank you for sharing with us. huntsville al therapist
ReplyDeleteAmazing article. Thanks for sharing with us.
ReplyDeletevisit our website for Commercial painting services boston