MySQL - Create, Delete User Accounts and Grant Privileges (create/drop user, grant, show grants)
HTML-код
- Опубликовано: 6 окт 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.
Thank you Eli for being there and being a great teacher
Finally found a another great teacher on the internet!!
I love the way you explained everything. So easy to understand.
Thank you.
The best security tip ever for a web developer using mysql
Eli you are the best, greetings from Macedonia!!!
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
best linux guy on youtube hands down. Knows his stuff
amazing lesson!clearer than our school lecturer🎉
Greetings from Mexico, you're the best!!!
Great learning. Thx Eli
Great video. I appreciate the best practices commentary. Also, how about showing the computer use using MySQL Workbench?
Sir Eli, Greetings from India!!!
thank you so much for this video
17:24 perfect comedic timing 🤣
I had to subscribe immediately
Very good man.
Who else thought why jason statham here?? 🤣
Took some time off the channel, I need to catch up with awesome new content!
Loved it!!!
Loved it
thank you so much
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
I have accidently deleted all the users. Now receiving an error and wont let me connect to phpmyadmin? Any help would be greatly appreciated
good stuff
grrreat!!
DOPE
👏