Shulou(Shulou.com)05/31 Report--

This article shows you what the permission fields of the User table in Mysql are, which are concise and easy to understand, which can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

What are the permission fields of the MysqlUser table

Select_priv . Determines whether the user can select data through the SELECT command.

Insert_priv . Determines whether the user can insert data through the INSERT command.

Update_priv . Determines whether the user can modify existing data through the UPDATE command.

Delete_priv . Determines whether the user can delete existing data through the DELETE command.

Create_priv . Determines whether users can create new databases and tables.

Drop_priv . Determines whether users can delete existing databases and tables.

Reload_priv . Determines whether users can perform specific commands to refresh and reload various internal caches used by MySQL, including logs, permissions, hosts, queries, and tables.

Shutdown_priv . Determine if the user can shut down the MySQL server. Great care should be taken when granting this permission to any user outside the root account.

Process_priv . Determine whether users can view the processes of other users through the SHOWPROCESSLIST command.

File_priv . Determine whether the user can execute the SELECTINTOOUTFILE and LOADDATAINFILE commands.

Grant_priv . Determines whether a user can grant permissions that have been granted to the user himself to other users. For example, if a user can insert, select, and delete information from an foo database and grant GRANT permissions, the user can grant any or all of his or her privileges to any other user in the system.

References_priv . Currently it's just a placeholder for some future functionality; it doesn't work now.

Index_priv . Determines whether the user can create and delete table indexes.

Alter_priv . Determines whether the user can rename and modify the table structure.

What are the permission fields of the MysqlUser table

Show_db_priv . Determines whether the user can view the names of all databases on the server, including those to which the user has sufficient access. Consider disabling this permission for all users, unless there is a particularly irresistible reason.

Super_priv . Determine whether users can perform some powerful administrative functions, such as deleting user processes through KILL commands, modifying global MySQL variables using SETGLOBAL, and executing various commands about replication and logging.

Create_tmp_table_priv . Determines whether the user can create a temporary table.

Lock_tables_priv . Determines whether the user can use the LOCKTABLES command to block access / modification to the table.

Execute_priv . Determines whether the user can execute the stored procedure. This permission only makes sense in MySQL5.0 and later versions.

Repl_slave_priv . Determines whether the user can read the binary log files used to maintain the replicated database environment. This user is located in the main system and facilitates communication between the host and the client.

Repl_client_priv . Determines whether the user can determine the location of the replication slave server and the master server.

Create_view_priv . Determines whether the user can create a view. This permission only makes sense in MySQL5.0 and later versions. For more information about views, see Chapter 34.

Show_view_priv . Determines whether the user can view the view or understand how the view is executed. This permission only makes sense in MySQL5.0 and later versions. For more information about views, see Chapter 34.

Create_routine_priv . Determines whether the user can change or discard stored procedures and functions. This permission is introduced in MySQL5.0.

Alter_routine_priv . Determines whether the user can modify or delete storage functions and functions. This permission is introduced in MySQL5.0.

Create_user_priv . Determines whether the user can execute the CREATEUSER command, which is used to create a new MySQL account.

Event_priv . Determines whether the user can create, modify, and delete events. This permission is added by MySQL5.1.6.

Trigger_priv . To determine whether the user can create and delete triggers, this permission is added by MySQL5.1.6.

What are the permission fields of the User table in Mysql? have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to 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.