In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article introduces the relevant knowledge of "what is the content and use of the MySQL5.6 authorization form". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!
The MySQL authorization table has five tables: user, db, host, tables_priv, and columns_priv.
The contents of the authorization form are used for the following purposes:
User table
The user table lists the users who can connect to the server and their passwords, and it specifies what kind of global (superuser) permissions they have. Any permissions enabled in the user table are global and apply to all databases. For example, if you enable DELETE permission, the users listed here can delete records from any table, so think carefully before you do so.
Db table
The db table lists databases, and users have access to them. The permissions specified here apply to all tables in a database.
Host table
The host table is used in conjunction with the db table to control the access of a specific host to the database at a better level, which may be better than using db alone. This table is not affected by GRANT and REVOKE statements, so you may find that you are not using it at all.
Tables_ privy table
The tables_priv table specifies table-level permissions, and one permission specified here applies to all columns of a table.
Columns_ privy table
The columns_priv table specifies column-level permissions. The permissions specified here apply to specific columns of a table.
This is the end of the content and purpose of the MySQL5.6 authorization form. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.