Get the App
SLTechnology News&Howtos  ›  Database  › 

What permissions does MYSQL specify for users?

Shulou Source: shulou.com Published: 2022-06-01 19:31:28 11月16日 Update

Let's learn what permissions MYSQL has for users. I believe you will benefit a lot after reading it. The text is not in essence. I hope that MYSQL has what permissions for users to specify this short content is what you want.

When assigning user permissions, nothing more than query, modify, delete, and some other mysql operation commands, here is a summary of all the commands.

Select_priv query command

Insert_priv insert command

Update_priv modify command

Delete_priv delete command

Create_priv creation command

Drop_priv deletes tables and databases

Reload_priv overload command

Shutdown_priv shutdown command

Process_priv command

File_priv file command

Grant_priv authorization command

References_priv foreign key command

Index_priv indexing command

Alter_priv add command

After reading this article on what MYSQL assigns permissions to users, many readers will want to know more about it. For more industry information, you can follow our industry information section.

Tags: Commands permissions users content more industries queries affirmations benefits information orders data databases files text times friends columns articles indexes Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information vpn OPPO Reno Apple MySQL