如何理解mysql权限参考
发布时间：2022-01-13 14:00:57 所属栏目：MySql教程 来源：互联网
导读：本篇文章为大家展示了如何理解mysql权限参考，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。 mysql日常管理和应用工作中，大家经常会涉及到授权问题，下面，我们就列举下权限相关的参考。 1、管理权限（Administ
|
本篇文章为大家展示了如何理解mysql权限参考，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。 mysql日常管理和应用工作中，大家经常会涉及到授权问题，下面，我们就列举下权限相关的参考。 1、管理权限（Administrative Privileges） Privilege Name Operation Enabled by Privilege CREATE USER Use high-level account-management statements FILE Read and write files on the server host GRANT OPTION Grant the account’s privileges to other accounts PROCESS View information about the threads executing within the server RELOAD Reload the grant tables or flush the logs or caches REPLICATION CLIENT Ask about master and slave server locations REPLICATION SLAVE Act as a replication slave server SHOW DATABASES See all database names with SHOW DATABASES SHUTDOWN Shut down the server SUPER Kill threads and perform other supervisory operations 2、对象权限（Object Privileges） Privilege Name Operation Enabled by Privilege ALTER Alter tables and indexes ALTER ROUTINE Alter or drop stored functions and procedures CREATE Create databases and tables CREATE ROUTINE Create stored functions and procedures CREATE TEMPORARY TABLES Create temporary tables using the TEMPORARY keyword CREATE VIEW Create views DELETE Delete rows from tables DROP Remove databases, tables, and other objects EVENT Create, drop, or alter events for the event scheduler EXECUTE Execute stored functions and procedures INDEX Create or drop indexes INSERT Insert new rows into tables LOCK TABLES Explicitly lock tables with LOCK TABLES statements REFERENCES Unused (reserved for future use) SELECT Retrieve rows from tables SHOW VIEW See view definitions with SHOW CREATE VIEW TRIGGER Create or drop triggers UPDATE Modify table rows 3、其他权限（Miscellaneous Privileges） Privilege Name Operation Enabled by Privilege ALL [PRIVILEGES] All operations (except GRANT) USAGE A special “no privileges” privilege 4、权限级别说明符（Privilege-Level Specifiers） Privilege Specifier Level at Which Privileges Apply ON *.* Global privileges:all databases, all objects in databases ON * Global privileges if no default database has been selected; database privileges for the default database otherwise ON db_name.* Database privileges: all objects in the named database ON db_name.tbl_name Table privileges: all columns in the named table ON tbl_name Table privileges: all columns in the named table in the default database ON db_name.routine_name Privileges for the named routine in the named database 上述内容就是如何理解mysql权限参考，你们学到知识或技能了吗？ （编辑：达州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
