MySQL - Create, Delete User Accounts and Grant Privileges (create/drop user, grant, show grants)

Find code and diagrams at: www.EliTheComp...
MySQL has its own user accounts and security policies. Remember that most times “hackers” are only able to compromise a database using the privileges assigned to the compromised account.
CREATE USER ‘user’@’localhost’ IDENTIFIED BY ‘password’; - Create user with Password
DROP USER ‘user’@’localhost’ - Delete user
GRANT ‘permission’ on DATABASE.TABLE to ‘user@localhost’; - Grant privileges to user account
GRANT ALL PRIVILEGES ON . TO ‘user’@’localhost’; - Gives all permissions to ALL tables on ALL databases to user
GRANT ALL PRIVILEGES ON . TO ‘user’@’localhost’ WITH GRANT OPTION; - “with grant option” gives ability for account to give privileges to other accounts.
GRANT ‘permission'(column1,column2) on DATABASE.TABLE to user@localhost; - Grants privilege to columns in a table.
show grants; - shows privilege of current user
show grant for user; shows privilege for a specific user
select user, host from mysql.user; - display users and hosts for MySQL Server
REVOKE ‘privilege’ on DATABASE.TABLE FROM user@localhost;
mysql -u username -p - Login to MySQL from Linux
Privileges:
ALL PRIVILEGES - grants all privileges to the MySQL user
CREATE - allows the user to create databases and tables
DROP - allows the user to drop databases and tables
DELETE - allows the user to delete rows from specific MySQL table
INSERT - allows the user to insert rows into specific MySQL table
SELECT - allows the user to read the database
UPDATE - allows the user to update table rows
Full list of Privileges: dev.mysql.com/...

[@killer909Y]

Taking a database class in college and the textbooks's exercises are complicated so I'm glad to have this series so I can have a better foundation. I also feel like you do a great job of explaining what real world situations you could find yourself in when interacting with databases.

[@oscarmartinlive]

I love the way you talk. Your flow of knowledge is engaging. The entrance is dope!

[@citoldyou]

Thank you Eli for being there and being a great teacher

[@marinasha2949]

Eli you are so good!!! "Good security is a by-product of good administration." (by Eli) That`s very refreshing.

[@manojsaravanan3824]

Finally found a another great teacher on the internet!!

[@fupreblog5756]

The best security tip ever for a web developer using mysql

[@rosaramirez8246]

I love the way you explained everything. So easy to understand. Thank you.

[@TomicaCZ]

Daaaaamn.... finally somebody who can actually do a proper informative video! Great job sir :) I learnt a lot, so thank you very much. btw your diction is awesome :D It might sound stupid, but it really helps to focus on all the information

[@budcostagingloginbudcostag3048]

best linux guy on youtube hands down. Knows his stuff

[@tonis864]

Eli you are the best, greetings from Macedonia!!!

[@christophernolan8761]

Great video. I appreciate the best practices commentary. Also, how about showing the computer use using MySQL Workbench?

[@jiayan9675]

amazing lesson！clearer than our school lecturer🎉

[@nguye1971]

Great learning. Thx Eli

[@joperez1980]

Greetings from Mexico, you're the best!!!

[@HarshSoni-x3j]

Sir Eli, Greetings from India!!!

[@anasofiaalves3937]

thank you so much for this video

[@outofahat9363]

17:24 perfect comedic timing 🤣

[@HowTo-nr7uk]

Who else thought why jason statham here?? 🤣

[@oscarmartinlive]

I had to subscribe immediately

[@marcelomafra]

Very good man.

[@VictorVii]

Took some time off the channel, I need to catch up with awesome new content!

[@gaurabroy4738]

Sir, while creating user an error is coming that error creating account newuser@%: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY' password" at line 1

[@uberfastross4348]

I have accidently deleted all the users. Now receiving an error and wont let me connect to phpmyadmin? Any help would be greatly appreciated

[@bebomohamed8860]

thank you so much

[@shamiks4976]

Loved it!!!

[@itprof7895]

Loved it

[@baruthiwagikuyutv]

good stuff

[@this_rishi]

grrreat!!

[@sandeshtimalsina]

DOPE

[@tawonganhende6007]

👏