2 Simple And Easy Ways To Create a MySQL New Users and Grant All Privileges

⭐2 Simple And Easy Ways To Create a MySQL New Users and Grant All Privileges⭐

In this Video we will cover how to create a New MySQL users and then Grant different Privileges for that user to perform actions on the database like read only user and DBA user so on. In doing so, we will see 2 different ways to achieve the same
1. Create Users via MySQL Workbench
2.Create users via MySQL Command Line.
***************************
Commands used in Video
***************************
CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'new_user'@'localhost';
FLUSH PRIVILEGES;
******************************
CREATE TABLE Customers (
CustomerName varchar(255),
ContactName varchar(255),
Address varchar(255),
City varchar(255),
PostalCode int,
Country varchar(255)
);
******************************
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', 4006, 'Norway');
******************************

▶️ How to Install & Configure MySQL on Windows 10/11 | Complete guide ???? https://youtu.be/rcFE0xaAjAM
__________________________
⏲️Time Stamps⏲️

0:30 - Overview
0:40 -
2:00 -
2:58 -
7:55 - Conclusion

▶️ How to Import CSV/Excel file to MySQL DB : ????https://youtu.be/k1Qnq940cmU
__________________________
Subscribe: | ????Make sure to enable ALL push notifications ????

▶️ Watch our latest videos: https://www.youtube.com/channel/UCH4j...
▶️ Elasticsearch java - Playlist : https://www.youtube.com/playlist?list...
▶️ MongoDB java Playlist : https://www.youtube.com/watch?v=WIhhz...
▶️ Spring Boot Java -Playlist : https://www.youtube.com/playlist?list...
▶️ MySQL Simplified Playlist : https://www.youtube.com/playlist?list...
__________________________

???? Twitter: https://www.twitter.com/simplifyingtech
???? Insta: https://www.instagram.com/simplifying...
--------------------------------------------------
Production Credits:

Edited by: Simplifying Tech
Edited with Tool : Filmora 10
Produced by: Simplifying Tech
WebSite: https://simplifyingtechcode.wordpress...
---------------------------------------------------
About Simplifying Tech :
???? Lets Make it Simplified and illustrative....
The main Objective of Simplifying Tech is to have people learn new technologies and programming in more simplified and illustrative way.
---------------------------------------------------