Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What is the content and purpose of the MySQL5.6 authorization form

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report