MySQL 8 Administrator???s Guide

Privileges provided by MySQL 8

Privileges define which operations are permissible to the user accounts. Based on the level of operation and the context in which it is applied, it will work. It is mainly classified as follows:

• Database privileges: Applied on the database, and all objects of the database within it. It can be granted to a single database or defined globally to apply on all databases.
• Administrative privileges: It is defined at the global level, so not restricted to a single database. It enables users to manage operation of the MySQL 8 server.
• Database object's privileges: It is used to define privileges on the database objects, such as tables, views, indexes, and stored routines. It can be applied on a specific object of the ...