MySQL - Create, Delete User Accounts and Grant Privileges (create/drop user, grant, show grants)
Vložit
- čas přidán 8. 09. 2024
- 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/...
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.
I love the way you talk.
Your flow of knowledge is engaging.
The entrance is dope!
Eli you are so good!!!
"Good security is a by-product of good administration." (by Eli)
That`s very refreshing.
Finally found a another great teacher on the internet!!
Thank you Eli for being there and being a great teacher
The best security tip ever for a web developer using mysql
I love the way you explained everything. So easy to understand.
Thank you.
Eli you are the best, greetings from Macedonia!!!
best linux guy on youtube hands down. Knows his stuff
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
17:24 perfect comedic timing 🤣
amazing lesson!clearer than our school lecturer🎉
Sir Eli, Greetings from India!!!
Great video. I appreciate the best practices commentary. Also, how about showing the computer use using MySQL Workbench?
Greetings from Mexico, you're the best!!!
Great learning. Thx Eli
thank you so much for this video
Who else thought why jason statham here?? 🤣
I had to subscribe immediately
Took some time off the channel, I need to catch up with awesome new content!
Very good man.
thank you so much
Loved it
Loved it!!!
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
good stuff
I have accidently deleted all the users. Now receiving an error and wont let me connect to phpmyadmin? Any help would be greatly appreciated
grrreat!!
DOPE
👏