Privilege refers to the right or authorization that can be granted to a user account, and it defines which operations can be performed by that account. MySQL privileges are of three types. These types specify the context in which they apply and their scope and are as follows:
- Administrative privileges: These privileges are used to enable users to manage the operations of MySQL server. They are applied globally due to their inability to be applied to a single database.
- Database privileges: These privileges apply to an entire database and all of its objects. You can apply them to a particular database or they can be applied globally to affect all databases (scope).
- Privileges for specific database objects: These can be applied to the following:
- Database objects such as tables, indexes, routines that are stored, and views.
- They can also be applied...
