Shulou(Shulou.com)06/01 Report--

This article mainly explains how to achieve mysql user rights management, the content is clear, interested friends can learn, I believe it will be helpful after reading.

The content of this article is:

What are appropriate user permissions? user permissions? view permissions? modify permissions? delete permissions?

Launch date: 2018-04-19

What are user rights: each user has their own user rights, such as query table rights, modify table rights, insert table rights, new user rights, and so on. Specific permissions: appropriate user permissions: most users only need to read and write tables, but a few users even need to be able to create and delete tables; some users need to read tables, but may not need to update tables; for most users, only read and write to tables should be provided, and they should not be allowed to create, modify, and delete tables. For most users, they should not be given permission to create, modify and delete other users, but only administrators should have such permission. For most users, you should not be given permission to modify user permissions, but only administrators should have such permissions. Others. View permissions: show grants for user name @ host address; [if the user's login address is%, you can also view the permissions by viewing user information: select * from user\ G the priv field in the user information table has various permissions. The value N means there is no permission, and Y means you have the permission to modify: permission: grant permission on database name. The data table to user name @ logon address; [if the user's login address is%, you can not enter the login address]. The new permissions will be compared with the original, and multiple permissions can be given at the same time in the same database. Multiple permissions can be separated by commas: refresh permissions: flush privileges. [the modified user permissions will not take effect immediately. If you want to take effect immediately, you need to refresh the permissions] the permissions that can be granted (see mysql):

Delete permission: delete permission: revoke permission on database name. Data sheet from user name @ login address; [if the user's login address is%, you don't have to fill in the login address] after reading the above, do you have a further understanding of how to achieve mysql user rights management? if you want to learn more, please follow the industry information channel.

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.